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)
Bookmarks