+ Reply to Thread
Results 1 to 4 of 4

Positive Results

  1. #1
    lmthomas
    Guest

    Positive Results

    How can I use a formula to subtract a number in one cell from a number in
    another cell then display the result only if it is positive or greater than 0?

  2. #2

    Re: Positive Results

    It would look something like this:

    =IF(a1-a2>=0,a1-a2,"")


  3. #3
    Duke Carey
    Guest

    RE: Positive Results

    =if(a1>=b1,a1-b1,"")

    "lmthomas" wrote:

    > How can I use a formula to subtract a number in one cell from a number in
    > another cell then display the result only if it is positive or greater than 0?


  4. #4
    lmthomas
    Guest

    Re: Positive Results

    That did it! Thank you for your help.

    "[email protected]" wrote:

    > It would look something like this:
    >
    > =IF(a1-a2>=0,a1-a2,"")
    >
    >


+ Reply to Thread

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