Results 1 to 5 of 5

Calculate negative values

Threaded View

  1. #1
    Registered User
    Join Date
    05-06-2009
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    24

    Calculate negative values

    Hi All,

    I have a problem with a formula I am using to calculate reserve storage.

    I have tried using an advanced formula but it is not producing the result I need. Rather, my formula is displaying negative values in some cases (see attached reference file highlighted cell E13).

    If the formula is going to produce a negative value, I want it to display a blank cell instead.

    I have attached a working file for reference.

    Can someone point me in the right direction PLEASE?

    Thanks
    Attached Files Attached Files
    Last edited by creativefusion; 05-19-2009 at 06:33 AM.

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