Not sure how to use the IF function

[Brenda H]

I'm sure this is a simple formula but I've never really understood how to use the IF function properly. (not even 100% sure I need the IF function or some other function)

I have a simple formula where I'm multiplying the value of one cell by a set number =sum(B27*0.0575) in most cases the answer will return a negative number. How do I change the formula so if the answer is a negative it returns 0 instead of the negative number?


if the number is positive it needs to give the positive answer

[benishiryo]

hi Brenda. try:
=MAX(0,sum(B27*0.0575))

if you wish to use IF,
=IF(B27<0,0,sum(B27*0.0575))

[JimBobBowie]

Hi Brenda,

Try this.

Please Login or Register  to view this content.

JimBobBowie

[Brenda H]

Thank you, all three options worked.

Brenda