Looking For a Value in a Cell

Closed

Tom9o Posts 10 Registration date Monday February 18, 2013 Status Member Last seen September 15, 2013 - Feb 20, 2013 at 12:15 AM
rizvisa1 Posts 4478 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

Looking For a Value in a Cell
If cell contains date then return value ✓ - Excel Forum
Excel formula to check if cell contains a date - Excel Forum
Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
Conditional formatting if cell contains text - Excel Forum
Count if cell contains number - Excel Forum

2 responses

Answer 1 / 2

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Answer 2 / 2

Tom9o Posts 10 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

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

If a cell contains any text then add a value

help me to add particular cells

If cell = date return yes or no.

Formula to Find&replace blank cells in excel

Excel: If Date =, then enter a value

Similar discussions

Subscribe To Our Newsletter!