IF statements for returning true or false question.

[McNeil87]

Hello!

what does this If formula mean?
IF(cell2=true, IF(cell3=true,true,false),true)? Reason I ask if, it’s returning true but I need i should return false when I replicate it.

thank you!

 

[QuietRiot]

IF the value in cell2 is TRUE THEN
	IF the value in cell3 is TRUE THEN
		Output TRUE
	ELSE
		output FALSE
ELSE
	output TRUE

 

[McNeil87]

Thank you! May ask I for input how to fix this logic? I attached a screen shot of the logical test how the output shows results. It's out putting the true/false correctly. It's returning all logical tests as true, when they should return mostly False. I think it's the first part of the logical test that needs to have a false criteria listed with the logical test? What do you think?

Thank you!

 

[QuietRiot]

so IF(cell2=true, IF(cell3=true,true,false),false)?

IF the AG2 is TRUE THEN (check AH2)
	IF AH2 is TRUE THEN
		Output TRUE
	ELSE
		output FALSE
ELSE
	output FALSE (Because AG2 is FALSE)

 

[Peter_SSs]

Duplicate to Help with True/False Formula

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Whilst this was the original thread, I am locking this one since much more discussion has occurred in the other one.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.