Hi,
I'd like a formula that returns a 1 value if cell b2 and/or c2 have a value in them but d2, e2, f2 are blank.
Can anyone help me on this?
Much appreciated
David
Hi,
I'd like a formula that returns a 1 value if cell b2 and/or c2 have a value in them but d2, e2, f2 are blank.
Can anyone help me on this?
Much appreciated
David
May be:
=AND(B2&C2<>"",D2&E2&F2="")
Quang PT
Hi,
That returns a 1 if both are zero values.
I want a formula that will return a 1 in the following examples - if B2=0 and C2=VALUE, if B2=VALUE and C2 = 0, if B2=VALUE & C2=VALUE.
Many thanks,
David
Try this if B2 and C2 is numberic:
=--AND((B2+C2)>0,D2&E2&F2="")
Orwith cse.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks