Help with True/False Formula

[McNeil87]

Hello!

Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True, IF(AH2=TRUE,TRUE,FALSE),TRUE). The result brings True, but it actually needs to be False (for this specific case). Am I missing a 'False' statement after the first logical test? Any recommendations how I should write this would be great. All the data returns True, and that is not correct.

Thank you!

 

[sandy666]

Both cells AG and AH cannot be blank = if it will happen you'll get #VALUE!
if you don't want to see error, use =IFERROR(NOT(OR(AG2,AH2)),"")
or =IF(OR(ISBLANK(AG2),ISBLANK(AH2)),"",NOT(OR(AG2,AH2)))

 

[6StringJazzer]

Cell AG is a contract , and AH is a program.. So, IF Cell AG is a contract and part of a program, then return True. If Cell AG (contract) is a contract, BUT not part of a program, then return 'False.' IF AG is not a contract, and is not part of a program, return False.

I am confused by your wording, because if AG is "a contract," it is not a TRUE/FALSE value. Do you mean that AG is TRUE when something is a contract, and FALSE if it is not? And AH is TRUE if something is part of a program and FALSE if not?

Can it not be a contract, but still be part of a program? That is, is it possible for AG to be FALSE and AH to be TRUE?

If AG and AH do not show just TRUE or FALSE values, then what is in them?

 

[McNeil87]

Thank you!

 

[McNeil87]

Hi, I fig

I am confused by your wording, because if AG is "a contract," it is not a TRUE/FALSE value. Do you mean that AG is TRUE when something is a contract, and FALSE if it is not? And AH is TRUE if something is part of a program and FALSE if not?

Can it not be a contract, but still be part of a program? That is, is it possible for AG to be FALSE and AH to be TRUE?

If AG and AH do not show just TRUE or FALSE values, then what is in them?

Hi! I figured it out... I had to put quotes around the "True" and "False" because it was text and not values.

I guess I am confused how to know when to know to use quotes around True and False statements vs when not to. Any suggestions?

 

[sandy666]

TRUE / FALSE are Boolean values

Boolean algebra