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
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 20, 2013 at 05:54 AM
Related:
- Looking For a Value in a Cell
- If cell contains date then return value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
- Excel formula to check if cell contains a date - Excel Forum
- Based on the value in cells b77 b81 ✓ - Excel Forum
- Excel send value to another cell - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 20, 2013 at 01:06 AM
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
Tom9o
Posts
10
Registration date
Monday February 18, 2013
Status
Member
Last seen
September 15, 2013
Feb 20, 2013 at 05:36 AM
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
=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
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
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
