Looking For a Value in a Cell
Closed
Tom9o
Posts
10
Registration date
Monday 18 February 2013
Status
Member
Last seen
15 September 2013
-
20 Feb 2013 à 00:15
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 20 Feb 2013 à 05:54
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 20 Feb 2013 à 05:54
Related:
- What function can automatically return the value in cell c77
- Read cell 77 online - Best answers
- Which function can automatically return the value in cell c77 - Best answers
- What is the function of a hard drive - Guide
- Download automatically while roaming - Guide
- Thunderbird return receipt - Guide
- Based on the values in cells b77:b81, which function can automatically return the value in cell c77 ✓ - Excel Forum
- Name Values - Excel Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
20 Feb 2013 à 01:06
20 Feb 2013 à 01:06
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 18 February 2013
Status
Member
Last seen
15 September 2013
20 Feb 2013 à 05:36
20 Feb 2013 à 05:36
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 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
20 Feb 2013 à 05:54
20 Feb 2013 à 05:54
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
