Conditionals and how to use the FALSE output in a cell

[Jwan622]

I have written a few conditionals and the output of those functions are FALSE. I want to use that fact to write other conditionals. So, if cell 1 conditional reads FALSE, I want to write a conditional in cell 2 that uses the output FALSE in cell one. However, the FALSE output in cell 1 isn't text.

I don't want to copy/paste the output FALSE in another cell. What should I do? How do I utilize the output FALSE in a conditional statement?

Also, how do I set the color of the output of a conditional if it returns TRUE and set another color if the output returns FALSE.

 

[Jonmo1]

If A1 contains a formula that returns TRUE or FALSE
B1 can refer to that cell in an IF

=IF(A1,"do this if a1 is true","do something else if A1 is false")

 

[Momentman]

Then type the FALSE without quotes, like say =IF(A1=FALSE,3,4)

 

[Jonmo1]

You don't need to type the =FALSE bit
You can just reverse the valueiftrue and valueiffalse

=IF(A1,4,3)
same as
=IF(A1=FALSE,3,4)