Excel Query
This query is : Resolved
Vikas Jain
(Querist)
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
Parixit Namdhar
(Expert)
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
- Depreciation Chart Companies Act
- GST Audit whether Govt Companies are exempt?
- PTRC Show Cause Notice on Email
- Unable to File TDS Q2 Return – New TRACES Portal Error
- Capital Gail Exemption Certificate
- Issuing of delivery challan by seller of goods
- Taxation of crypto futures in India Fy 2026- 2027
- MSME disclosure and disallowance
- EPF ECR NEW RULES Sep 17th 2026
- Not ordinarily resident having partnership income in India and salary in USA is any form to filed be
- Accounting treatment of AMC alongwith the purchase of Laptop
- GST Treatment of Purchases with GST Paid where Outward Supplies of Manufactured CattleFeed Exempt
- Expert Help Required for TDS Refund 100000 Through TRACES – AY 2022–23
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
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
