Originally Posted by
Brigitte_P
You can try the following:
=if(a1<=50,a1*1.10,if(a1<=100,a1*1.15,if(a1<=150,a1*1.2,a1*1.25)))
This checks if the number is lesser than or equal to 50.
If it is, it multiplies by 1.10 (adds 10%).
Otherwise (number is greater than 50), it checks if the number is lesser than or equal to 100.
If it is, it multiplies by 1.15 (adds 15%).
Otherwise (number is greater than 100), it checks if the number is lesser than or equal to 150.
If it is, it multiplies by 1.20 (adds 20%).
Otherwise (number is greater than 150), it multiplies by 1.25 (adds 25%).
Excel does have a limit on the number of nested IFs it can handle, so if you have several more possible ranges than you do in your example, this may not work for you.
Brigitte
Bookmarks