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 767
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 767
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