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:
- What function can automatically return the value in cell c77
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
- Download automatically while roaming - Guide
- Wow equipment return ✓ - Network Forum
- Based on the values in cells b77 b88 what function can - Excel Forum
- Why is my instagram account automatically following people? ✓ - Instagram Forum
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
