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
rizvisa1 Posts 4479 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 (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- If cell contains specific text then return value in another cell vba ✓ - Excel Forum
- If cell contains text then return value in another cell ✓ - Excel Forum
- Run macro when cell value changes - Guide
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
2 replies
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
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
11
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
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
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