IF Formulas

[Paulcassin]

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
AND IF B3>100 but < 200 then the following applies (25*3) + ((B3-25) *1.4
AND IF B3>200 but < 600 then the following applies (25*3) + ((B3-25) *1.1?

 

[Michael M]

There might be a better way, but we'd need more info on the actual data

=IF(B3<15,50,IF(B3<25,75,IF(B3<50,75+(B3-25)*2,IF(B3<100,75+(B3-25)*1.6,IF(B3<200,75+(B3-25)*1.4,75+B3-25)*1.7))))

 

[Paulcassin]

thanks