# Changing negative value to 0

1. ## Changing negative value to 0

Hello

I was hoping somebody could help please.

I have a spreadsheet that contains formulas, which show negative values at times, but i dont wish these to be shown.

For instance, in cell f3, contains =f5-f6 , but when it is negative i wish it to show 0. is this possible.

Any help would be appreciated.

Kind regards

Joe

2. ## Re: Changing negative value to 0

Try:

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

3. ## Re: Changing negative value to 0

Try this

=IF(F5-F6<0,0,F5-F6)

Hope this helps

4. ## Re: Changing negative value to 0

If you wish it to appear as 0 but retain its value for downstream calculation (kindof a bad idea, I think), then you can format as, for example, General;"0";0

If you want the downstream result to be 0, then change the formulas to =MAX(0, your formula)

5. ## Re: Changing negative value to 0

thanks for all your help, all much appreciated, i went for the max one in the end, but thanks all.

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