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