Excel Query
This query is : Resolved
13 June 2009
RANGE VALUE
1 50 15
51 100 18
101 150 19
151 200 7
201 250 26
251 300 32
301 350 109
351 400 55
For Ex :- if we put 68 in F4, value is 18 should come in F7. because 68 is fall under the range value of 51-100.
please advice me how I can do that with the help of excel formulas
1 50 15
51 100 18
101 150 19
151 200 7
201 250 26
251 300 32
301 350 109
351 400 55
For Ex :- if we put 68 in F4, value is 18 should come in F7. because 68 is fall under the range value of 51-100.
please advice me how I can do that with the help of excel formulas
16 June 2009
=IF(F4>400,"N.A.",IF(F4>350,55,IF(F4>300,109,IF(F4>250,32,IF(F4>200,26,IF(F4>150,7,IF(F4>100,19,IF(F4>50,18,15))))))))
Paste this syntex
good bye
Paste this syntex
good bye
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- CG Tax On residential property
- Applicable TDS for Purchase of Flat from NRI
- Claiming exemption of perquisite for employee-owned car under New Tax Regime in ITR-2
- PPF interest-As Exempt Income disclosure
- Under construction property in ITR
- Gift of mutual fund units to daughter
- Building tax payment deduction in rental Income
- Upload Level ValidationITR3Category of Defect B/D
- Not able to file ITR
- NRI ITR2 account in 2025-26 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,.
- Section 194JA & JB Income which ITR Form to use
- Pass word to open justification report for Q1 for FY 2026-27
- PF Taxable Income
- Clarification on Tax Audit Applicability and Reporting of F&O Transactions in ITR-3
- Interest credited in FY2025-2026 & TDS therein by EPFO does not reflect in AIS or Form 26AS
- 44ad eligble money lending interest
- Delisted shares sold in off market/ Rebate u/s87A
- In Exports Sales HSN details where to fill
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- Difference in tax comparison report
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
