Excel Query


This query is : Resolved 

(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

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


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details
Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details
Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details
Company
23 October 2026
Sr. Accountant

SANKARAN & KRISHNAN

New Delhi

B.Com

View Details
Company
21 October 2026
CA INTER/ BCOM WITH EXPERIENCE

CA S KUMAR GUPTA & CO

Amritsar

CA Inter

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details