If statements that need help!

[SPENY]

Here's my dilema.

I'm trying to make a formula that if the end result number results in a negative number, then it would automatically go to 0

For instance, this is what I have written so far...

=IF(D2="Yes",2.25*(E2-180)+350,IF(K2<=0,0))

I can't figure out how to tell it to say 0 if it's below 0..

So as you can see above, if D2 cell says yes, it will multiply 2.25 by e2-180+350. But I want it to also state that if it's NO then it will say 0 in that cell(k2). ALSO wanting to keep it at 0 because it's of mileage and certain loads.

So from 0-180 it will result in a negative number. After 180 I want it to start calculating the IF="YES" statements.

Any help?

[martindwilson]

=max(IF(D2="Yes",2.25*(E2-180)+350,IF(K2<=0,0)),0)

[SPENY]

My god you saved my day. Thank you SO much!