I'm trying to get an IF formula to produce a result depending on what is in B12 (please see formula below). While this formula works, it is limited to 10 nested formulas and I may need to go up to 25. The purpose of the formula is to add $1500 for each occurence after 3. For example if the client has 1-3 systems, the flat fee is $10,000, each system after that is going to cost them $1500 per. How do I write this?
=IF($B$12<=3,3500,IF($B$12=4,4500,IF($B$12=5,6000,IF($B$12=6,7500,IF($B$12=7,9000,IF($B$12=8,10500,IF($B$12=9,11500,IF($B$12=10,13000))))))))
Bookmarks