a1-b1 if greater than zero then show result otherwise don't

[Hoopsah]

Head scratcher for me I'm afraid

A1 - B1

If the answr is greater than zero then show the result, else show a zero

Any one got a clue about this?

 

[AlanY]

=max(a1-b1,0)

 

[tyija1995]

Hey Hoopsah,

Try using an IF formula,

IF(A1-B1<=0, 0, A1-B1)

 

[Hoopsah]

Thank you Alan and Tyija - both work like a charm

Just saved me from drawing blood I was scratching my head so hard

Thanks again

 

[AlanY]

you're welcome