HOW I US "IF" FORMULS ATLEAST 15times,

[zahida]

IF(K22>1200000,K22*11/100,IF(K22>1050000,K22*10/100,IF(K22>900000,K22*9/100,IF(K22>750000,K22*7.5/100,IF(K22>650000,K22*6/100,IF(K22>550000,K22*4.5/100,IF(K22>450000,K22*3.5/100,IF(K22>400000,K22*2.5/100,IF(K22>350000,K22*1.5/100,IF(K22>250000,K22*0.75/100,IF(K22>180000,K22-180000)*0.25/100))))))))))

please correct if there is any error in said fomula

 

[Niek Otten]

Look here:

http://www.j-walk.com/ss/excel/usertips/tip080.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
IF(K22>1200000,K22*11/100,IF(K22>1050000,K22*10/100,IF(K22>900000,K22*9/100,IF(K22>750000,K22*7.5/100,IF(K22>650000,K22*6/100,IF(K22>550000,K22*4.5/100,IF(K22>450000,K22*3.5/100,IF(K22>400000,K22*2.5/100,IF(K22>350000,K22*1.5/100,IF(K22>250000,K22*0.75/100,IF(K22>180000,K22-180000)*0.25/100))))))))))
|
| please correct if there is any error in said fomula

 

[Don Guillett]

Have a look in the help index for LOOKUP