Looking For a Value in a Cell

[Closed]
Report
Posts
11
Registration date
Monday February 18, 2013
Status
Member
Last seen
September 15, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I am using the following formula below

=IF(OR(A1=" ",B1=" ",C1=" ",D1=" ")" ",G1)

What I am trying to do is if all the cells are blank I want to return a blank in the cell that the formula is in but any of the cells contains something then I want it to return the value in cell G1 it will work if all the cells are blank but it will not when one, two, or three, cells have value it is only when they all have a value in them that works as well but I said I need it to work when only one of the cell has a value in it
It's dates that are in the cells A1,B1,C1,D1, I don't know if that will make a different.

Thanks

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
reverse your logic. instead of checking for "=" test for "<>". so if at least one cell is not blank, you can do whatever you want to do
Posts
11
Registration date
Monday February 18, 2013
Status
Member
Last seen
September 15, 2013

Hi rizvisal thanks again for helping me just want to check that I understand and inputting it correctly I have now changed the formula

=IF(OR(A1<>" ",B1<>" ",C1=" ",D1=" ")" ",G1)

But when I do this it still does not work
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
No
like this
=IF(OR(A1<>" ",B1<>" ",C1<>" ",D1<>" "), G1, " ")
so if a1 or b1 or c1 or d1 is blank,then show g1 else show blank