HOW I US "IF" FORMULS ATLEAST 15times,
 

IF(K221200000,K22*11/100,IF(K221050000,K22*10/100,IF(K22900000,K22*9/100,IF(K22750000,K22*7.5/100,IF(K22650000,K22*6/100,IF(K22550000,K22*4.5/100,IF(K22450000,K22*3.5/100,IF(K22400000,K22*2.5/100,IF(K22350000,K22*1.5/100,IF(K22250000,K22*0.75/100,IF(K22180000,K22-180000)*0.25/100))))))))))

please correct if there is any error in said fomula

HOW I US "IF" FORMULS ATLEAST 15times,
 

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"zahida" wrote in message ...
|
IF(K221200000,K22*11/100,IF(K221050000,K22*10/100,IF(K22900000,K22*9/100,IF(K22750000,K22*7.5/100,IF(K22650000,K22*6/100,IF(K22550000,K22*4.5/100,IF(K22450000,K22*3.5/100,IF(K22400000,K22*2.5/100,IF(K22350000,K22*1.5/100,IF(K22250000,K22*0.75/100,IF(K22180000,K22-180000)*0.25/100))))))))))
|
| please correct if there is any error in said fomula

HOW I US "IF" FORMULS ATLEAST 15times,
 

Have a look in the help index for LOOKUP

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"zahida" wrote in message
...
IF(K221200000,K22*11/100,IF(K221050000,K22*10/100,IF(K22900000,K22*9/100,IF(K22750000,K22*7.5/100,IF(K22650000,K22*6/100,IF(K22550000,K22*4.5/100,IF(K22450000,K22*3.5/100,IF(K22400000,K22*2.5/100,IF(K22350000,K22*1.5/100,IF(K22250000,K22*0.75/100,IF(K22180000,K22-180000)*0.25/100))))))))))

please correct if there is any error in said fomula