How do I write the following excel formula:
If B3 < 15 then the following applies 25*2=50
AND IF B3 > 15 but < 25 then the following applies (25*3)
AND IF B3 > 25 but <50 then the following applies (25*3) + ((B3-25) *2
AND IF B3>50 but < 100 then the following applies (25*3) + ((B3-25) *1.6...