LinkBack URL
About LinkBacks
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
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
Last edited by Tgbell; 07-09-2019 at 09:11 AM.
Hi Tgbell,
Does this cover what you need:
Hope this helps.
Please Login or Register to view this content.
Snook
Just..
=AND(B2="",C2="")
Will do the same
Maybe
=AND(OR(B2="",B2=0),OR(C2="",C2=0))
I just used IF(OR(B2<>"",C2<>""), "TRUE", "FALSE")
Hi @Tgbell
Your formula do not solve the problem you put in OP#1 "IF B2 AND C2 are both blank".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks