IF AND Forumlas

[Paulcassin]

How do I write the following excel formula: If B3 < 25 then the following applies 25*3=$75 AND IF B3 > 25 but < 50 then the following applies (25*3) + ((B3-25) *2 AND IF B3 > 50 then the following applies (25*3) + ((B3-25) *1.5?

 

[Fluff]

How about
=IF(B3<=25,25*3,IF(B3<=50,75+((B3-25)*2),75+((B3-25)*1.5)))

 

[Paulcassin]

thanks

 

[Fluff]

You're welcome