# Show zero value instead of a minus number

1. ## Show zero value instead of a minus number

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

2. ## Re: Show zero value instead of a minus number

Use MAX

``Please Login or Register  to view this content.``

3. ## Re: Show zero value instead of a minus number

=max(0,a3-b1)

4. ## Re: Show zero value instead of a minus number

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1