Easy Office
LCI Learning

Excel Query

This query is : Resolved 
Profile Image

Profile Image

(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
Profile Image

Parixit Namdhar

Profile Image

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

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

CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries



Trending Online Classes

view all classess
CCI Pro


Answer Query



Quick Links