IF Formula to calculate blank cells

[Tgbell]

Good Morning,

I need to create an IF equation to: IF B2 AND C2 are both blank (due to a formula not filling, so not sure if it is blank or 0 since there is still a formula in cell) then if true put TRUE if false put FALSE

[The_Snook]

Hi Tgbell,

Does this cover what you need:

Please Login or Register  to view this content.

Hope this helps.

Snook

[Roel Jongman]

Just..

=AND(B2="",C2="")

Will do the same

[José Augusto]

Maybe

=AND(OR(B2="",B2=0),OR(C2="",C2=0))

[Tgbell]

I just used IF(OR(B2<>"",C2<>""), "TRUE", "FALSE")

[José Augusto]

Hi @Tgbell
Your formula do not solve the problem you put in OP#1 "IF B2 AND C2 are both blank".