Results 1 to 25 of 25

Formula Results as False when True

Threaded View

  1. #1
    Registered User
    Join Date
    12-16-2020
    Location
    US
    MS-Off Ver
    2013
    Posts
    14

    Formula Results as False when True

    Hello,

    I have created a spreadsheet to help me calculate an agents non-productive time. In this spreadsheet I have a few formulae (formulas?) that reference each other. My problem, is that some of these formulae (as?) come up showing that something is false, when it is in fact true. IE N-O=0 it should read "Good" if this is true, but instead it reads as False and moves on to the next part of the formula. The same formula on a different row works exactly as expected. The only difference I can tell is that the formula that doesn't work as intended references another formula that uses a different part of the IF statement. Examples below:

    Working Formulas (ae?)
    =IFERROR(IF(C5="","",(MOD(C5-B5,1)*24-D5)),IF(C5="","",(MOD(C5-B5,1)*24))) -- This Formula is using the underlined function
    =IFS(F5="Coordinator","",F5="Escalation Agent",N5*0.6,F5="Training","",N5-O5=0,"GOOD",N5-O5<>0,N5-O5)
    Non-Working Formulas (ae?)
    =IFERROR(IF(C3="","",(MOD(C3-B3,1)*24-D3)),IF(C3="","",(MOD(C3-B3,1)*24))) -- This Formula is using the underlined function 
    =IFS(F3="Coordinator","",F3="Escalation Agent",N3*0.6,F3="Training","",N3-O3=0,"GOOD",N3-O3<>0,N3-O3) -- N3-03 does indeed equal zero, so the underlined portion should be true but is reading as false and moving on to the bold portion
    I know this may not be the cleanest way to do this (or it may be, I'm not sure because I'm not a complete expert on excel functions, I just know enough to get by), but if you could help me understand why it's reading as false, that would be very helpful! Thank you! (worksheet should be attached)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] IF formula using other cell values as true/false results
    By kschmit1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-20-2017, 08:22 AM
  2. [SOLVED] want results as true or false
    By abubaniyan in forum Excel General
    Replies: 3
    Last Post: 12-10-2014, 06:33 AM
  3. Countifs Formula that show True/False results?
    By Kid Wonder in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-12-2013, 12:57 PM
  4. [SOLVED] I Need Help Creating a Formula to That Sorts True/False Results
    By artiststevens in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-09-2013, 07:38 AM
  5. Replies: 14
    Last Post: 06-27-2012, 04:26 PM
  6. Formula that will give me True or False results
    By Reenee in forum Excel General
    Replies: 2
    Last Post: 02-02-2009, 10:36 AM
  7. Adding True False Results
    By Arla M in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-27-2005, 03:06 PM

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