Looking For a Value in a Cell
Closed
Tom9o
rizvisa1
- Posts
- 11
- Registration date
- Monday February 18, 2013
- Status
- Member
- Last seen
- September 15, 2013
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Looking For a Value in a Cell
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Forum - Excel
- It restricts what values are possible for cells that contain numbers, dates, and text ✓ - Forum - Excel
- Macro copy and paste in next blank cell - Guide
- Excel if cell contains date then return value ✓ - Forum - Office Software
- Google sheets if cell contains any text then ✓ - Forum - Excel
2 replies
rizvisa1
Feb 20, 2013 at 01:06 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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
Feb 20, 2013 at 05:36 AM
- 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
=IF(OR(A1<>" ",B1<>" ",C1=" ",D1=" ")" ",G1)
But when I do this it still does not work
rizvisa1
Feb 20, 2013 at 05:54 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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