HOW I US "IF" FORMULS ATLEAST 15times,

Z

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
 
N

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting Excel 2007 Nested "If" Statement to Excel 2003: Overcom 4
Data input and result on userform using function assignment 2
database designing for paying monthly salary 1
Found a Bug or Error in Access 2002-2003 Round Function 3
Variable not returning/passing value 10
Setting form control value to a variable in VBA 6

Top