Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    If function (97)

    Hello, how do I code a formula to achieve my requirments in this scenario:

    I want my cell to return a value of 0 if the calulation from other cells returns a negative number else return the value of those other cells if positive? i.e. in G5 if D5 - D4 is negative return 0 else return the positive value from D5-D4?

    Thanks Darren.

  2. #2
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Louisville, Kentucky, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: If function (97)

    In your specific case, I like =MAX(0,D5-D4). If you really prefer IF, then =IF(d5-d4<0,0,d5-d4).

Posting Permissions

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