Results 1 to 5 of 5

Changing negative value to 0

Threaded View

  1. #1
    Registered User
    Join Date
    09-23-2009
    Location
    liverpool, england
    MS-Off Ver
    Excel 2003
    Posts
    78

    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
    Last edited by sandbach; 11-05-2010 at 01:59 PM.

Thread Information

Users Browsing this Thread

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

Bookmarks

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