Previous Topic Next Topic

Looking For a Value in a Cell

Closed
Tom9o
Posts
11
Registration date
Monday February 18, 2013
Status
Member
Last seen
September 15, 2013
 - Feb 20, 2013 at 12:15 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 - Feb 20, 2013 at 05:54 AM
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

Answer 1 / 2
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 770
Feb 20, 2013 at 01:06 AM
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
0
Answer 2 / 2
Tom9o
Posts
11
Registration date
Monday February 18, 2013
Status
Member
Last seen
September 15, 2013
Feb 20, 2013 at 05:36 AM
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
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 770
Feb 20, 2013 at 05:54 AM
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
0