Show zero value instead of a minus number

[jtopup]

Hi all....very firsy post, bit of a noob..
I need help with a formula that will give me a 0 (zero) value
cell A1+A2 sum in A3....no problem here
Then in A4 I need a sum of another cell total lets say B1 taken away from sum in A3
e.g A1=10
A2=10
sumA3=20 if cell B1 is more than 20 it will give a negative number
I need A4 to show 0 or the positive number
tried for hours any help please

[DonkeyOte]

Use MAX

Please Login or Register  to view this content.

[NBVC]

=max(0,a3-b1)

[jtopup]

Thank you DonkeyOte....never knew it was so simple....again thanks