+ Reply to Thread
Results 1 to 8 of 8

The formula is not giving the correct result

  1. #1
    Forum Contributor
    Join Date
    10-27-2013
    Location
    Ireland
    MS-Off Ver
    Microsoft 365
    Posts
    403

    The formula is not giving the correct result

    im using this for a delivery formula

    =IF(R3=2,"Delivered",IF(S3=2,"Not elivered",IF(R3+S3=3,"Delivered",IF(R3+S3=4,"Delivered",IF(R3+S3=5,"Delivered",IF(R3+S3=6,"Delivered",IF(R3+S3=7,"All Delivered","Check status")))))))

    when it goes as far as if(r3+S3=2,Not delivered" thats as far as it goes the calculations are correct except it does not show delivered if r3+s3=4 it doesnt say delivered it says not delivered (There are no spaces in the formula this is just the way it came up when i pasted it here)
    Last edited by Patcheen; 07-02-2016 at 11:13 AM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Not getting proper result

    Please change the title of question to a more appropriate one, according to the forum rules.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Contributor
    Join Date
    10-27-2013
    Location
    Ireland
    MS-Off Ver
    Microsoft 365
    Posts
    403

    Re: Not getting proper result

    How do i change it

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: The formula is not giving the correct result

    Above the first question, you find the option on the right hand side.

    Second, you get better help if you add a small excel file, without confidential information.

    Please also add manualy the expected result in your file.

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,152

    Re: The formula is not giving the correct result

    You need to look at the order of your checks:

    R3=1, R3=2 then R3+S3=3 BUT as R3 is 2 this test will never execute. (=IF(R3=2,"Delivered"

    if R3=2 and S3=2 R3+S3=4 but again this check will never be executed. (=IF(R3=2,"Delivered",IF(S3=2,"Not Delivered"...

    Probably need to reverse the order

    i.e. =IF(R3+S3=7,"All Delivered",IF(R3+S3=6,"Delivered",........

  6. #6
    Forum Contributor
    Join Date
    10-27-2013
    Location
    Ireland
    MS-Off Ver
    Microsoft 365
    Posts
    403

    Re: The formula is not giving the correct result

    will try that now that you

  7. #7
    Forum Contributor
    Join Date
    10-27-2013
    Location
    Ireland
    MS-Off Ver
    Microsoft 365
    Posts
    403

    Re: The formula is not giving the correct result

    sorted thank you John

  8. #8
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,152

    Re: The formula is not giving the correct result

    You're welcome. Thank you for the feedback and rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 11-27-2015, 11:12 AM
  2. Proper way to handle not result with .find?
    By wawamr2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-02-2015, 03:05 AM
  3. Replies: 1
    Last Post: 01-25-2013, 01:58 PM
  4. why the result is not a proper B2= C2+ OldValueC2 ?
    By omega0010 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-30-2012, 10:16 AM
  5. Disable Solver Result Dialog Box & Display Result in Cell
    By yauchildchew in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-04-2010, 01:46 PM
  6. Advanced formula - Return result & Show Cell Reference of result
    By Irv in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-05-2006, 10:40 PM
  7. [SOLVED] Formula Showing In A Cell Instead of Proper Result
    By DanK in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-04-2006, 02:46 AM

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