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
- Is this income indian or foreign income?
- REGARDING GST ON COMMERICIAL PROPERTY
- 15ca /15cb whose income tax login? remitter or nri seller's login?
- GST on export of services and Input Credit
- Regarding Documentation & Compliances for Opening of Unit of Pvt Ltd.
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- ITC temporary reversal and reclaim
- TDS U/S. 194NF
- Applicable TDS rate for sale of property in Nov 2024
- Tds on building rent monthly
- MIS MATCH OF INVOICE NUMBER
- VERIFICATION OF REFUND RELATED
- GST Regis.
- ITC c/f from FY2022-23 to FY2023-24 entered the same in table 8C of GSTR9 of FY 2022-23, in FY23-24
- Late filling fees Demand by gst office
- IGST Credit-Show cause notice issued-confusion
- Short and Excess provision of expenses
- Issue of gst e invoice
- Interchangeable words in accounts
- Adjusted profit/Loss in the case of LLP and Pvt. Ltd.company
Trending Online Classes
CAclubindia
