If conditions return no value

[BootsLopena]

My statement is not returning any value unless I manually input values for the statement to evaluate. Font is set to general. I intentionally have my condition values to be equal to a cell. Below is my formulas that should work. I’m stuck and frustrated. I think it’s self explanatory, but I’ve been looking at this way to long.

CELL I WANT TO ANSWER
yes/no for completed on time (this is populated by AG2, AH2, AND AF2)
=IF(AG2=1,"YES",IF(AH2=-1,"NO",IF(AF2=0,"")))


Yes on time (populated by yes on time calculated)
=AH2


Not on time (populated by not on time calculated)
=AI2


Blank value
AF2 nothing here


Yes on time calculated
=IF(NOT(AG2>=0),"","1")


Not on time calculated
=IF(NOT(AG2<0),"","-1")

 

[FDibbins]

what - exactly - is in AG2, AH2, AND AF2?

 

[jtakw]

My statement is not returning any value unless I manually input values for the statement to evaluate. Font is set to general. I intentionally have my condition values to be equal to a cell. Below is my formulas that should work. I’m stuck and frustrated. I think it’s self explanatory, but I’ve been looking at this way to long.

CELL I WANT TO ANSWER
yes/no for completed on time (this is populated by AG2, AH2, AND AF2)
=IF(AG2=1,"YES",IF(AH2=-1,"NO",IF(AF2=0,"")))


Yes on time (populated by yes on time calculated)
=AH2


Not on time (populated by not on time calculated)
=AI2


Blank value
AF2 nothing here


Yes on time calculated
=IF(NOT(AG2>=0),"", "1" )


Not on time calculated
=IF(NOT(AG2<0),"", "-1" )

Hi,

Without going further,

First try Removing the quote marks in Red in your formulas above, those quote marks made the 1 and -1 TEXT.
Then see how your other formulas are working out.

 

[BootsLopena]

Hi,

Without going further,

First try Removing the quote marks in Red in your formulas above, those quote marks made the 1 and -1 TEXT.
Then see how your other formulas are working out.

Its at work. But I can get the exact statement to work on another worksheet. That’s the confusing part. I’ll try in the morning. Thks

 

[BootsLopena]

One is 1
one is -1
one is blank
numbers that are pulled from another cell that has a nested statements. Thought maybe the statements were the issue.

 

[FDibbins]

Perhaps you missed my question in post #2 (put post 4 kinda partly answered it anyway)

My reason for asking is, unless AG2, AH2 and AF2 contain exactly 1, -1 and 0 (AND it is numeric, not text) , you will get "" for the answer

 

[FDibbins]

One is 1
one is -1
one is blank
numbers that are pulled from another cell that has a nested statements. Thought maybe the statements were the issue.

OK just because it shows 1, doesnt mean it contains a numeric 1 - it could be a text 1. What is the formula that produces the 1?