Results 1 to 5 of 5

Thread: Wrong Results

  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Could someone have a look at the attached spreadsheet. It's giving the wrong results. The figures are dimensional tolerances, and N23,N25 and N26 are showing False. The figures in C-F23, show that the dimensions are in tolerance, so the result in J23, should be pass. I suspect, that the formula in column N is incorrect, but I don't know what it should be. I didn't create the spreadsheet, I've just been asked to try and get it to show the correct figures.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I have no idea what it means, but try

    =IF(L23>0,L23,IF(M23<0,M23,0))

    in N23.

  3. #3
    New Lounger
    Join Date
    Dec 2009
    Location
    Anaheim, California, USA
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by robm View Post
    Could someone have a look at the attached spreadsheet. It's giving the wrong results. The figures are dimensional tolerances, and N23,N25 and N26 are showing False. The figures in C-F23, show that the dimensions are in tolerance, so the result in J23, should be pass. I suspect, that the formula in column N is incorrect, but I don't know what it should be. I didn't create the spreadsheet, I've just been asked to try and get it to show the correct figures.
    The problem with the formulas in N23, N25 and N26 is that both the if statements are false that's why you are getting those results. The formula provided by HansV gives the third option of returning zero when both the if statements are false.

  4. #4
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks guys. Hans formula does solve the problem. Thanks again.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Can you ask someone what the formulas are supposed to do?


Posting Permissions

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