Forum Discussion
Excel Formula
I am not an expert in excel formulas and I want to write formula that reflect the following: If I have a three brackets (0-70) / (70-100) / (any number over 100) And If there is any number fa...
Ahmed2500 Quick and ugly since I'm in a hurry, but put the number to be evaluated into E3 and use this formula:
=IF(0>$E$3>70,$E$3*0.05,IF(71>$E$3>99,(0.05*70)+(($E$3-70)*0.15),IF($E$3>100,(0.05*70)+(0.15*30)+($E$3-100))))
Also, here is a better forum for questions about Excel: