Max formula (=MAX(A11*B11, 70))

[richiwatts]

I use the formula to default to 70 if A11*B11 is less than 70.
How do I change this so it doesn't default to 70 if the calculation is 0?

Rich

 

[dreid1011]

Perhaps this:

=IF(A11*B11,MAX(A11*B11,70),0)

Replace the 0 If you want it to show some other result when it equals 0.

 

[richiwatts]

Thank you. That is what I needed.

 

[dreid1011]

You're welcome.