calculate a formula if a cell is true or not

[jwesleynca]

I want a cell to calculate one formula if it returns true and another if
not.

IE:
If the B2 is greater than 400, then it will calculate:
(((B2-400)/50)*3)+22.50 BUT only in multiples of 50 (ie. 450, 500,
550, etc.).

If B2 less than 400, then = 22.5

Any direction would be greatly appreciated!

Thanks,
James

 

[J.E. McGimpsey]

One way:

=MAX(22.5,INT(B2*0.06)-1.5)