J
JudithJubilee
Try
=IF(OR(BO82<>"",CK82<>""),TRUE,"")
Hope this helps
Judit
=IF(OR(BO82<>"",CK82<>""),TRUE,"")
Hope this helps
Judit
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Pat
The following formula will return TRUE if BO82 contains a value
=IF(BO82="","",IF(CK82="","",TRUE))
If CK82 has a value and BO82 does not it will not return TRUE
What do I need to change so that TRUE will display if either CK82 or BO82
contains a value.
Thanks if you can help.
Pat
=IF(BO82="","",IF(CK82="","",TRUE))
If CK82 has a value and BO82 does not it will not return TRUE
What do I need to change so that TRUE will display if either CK82 or BO82
contains a value.
Thanks if you can help.
Pat
A
Andy B
Pat
Try this:
=IF(OR(BO82="",CK82=""),"",TRUE)
Andy
Try this:
=IF(OR(BO82="",CK82=""),"",TRUE)
Andy
D
Debra Dalgleish
You can use the following formula:
=COUNTA(BO82,CK82)>0
=COUNTA(BO82,CK82)>0
P
Pat
Andy
Your formula only displays TRUE if both cells contain a value, I need it to
display TRUE if either or both contain a value. I forgot to mention that
both cells contain a formula and TRUE should not be returned if there is no
value on display.
Pat
Your formula only displays TRUE if both cells contain a value, I need it to
display TRUE if either or both contain a value. I forgot to mention that
both cells contain a formula and TRUE should not be returned if there is no
value on display.
Pat
J
JE McGimpsey
Change Andy's OR to AND:
=IF(AND(BO82="",CK82=""),"",TRUE)
=IF(AND(BO82="",CK82=""),"",TRUE)