Exact if not blank
Closed
Marleny
-
Jun 12, 2011 at 09:26 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 13, 2011 at 11:14 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 13, 2011 at 11:14 AM
Hello,
I use the formula below to compare two values as long as they are not blank
=IF(AND((A1<>""),(C1<>"")),EXACT(A1,C1),"-")
However, I need to compare the value in A1 against other cells within the same formula as long as none are blank
I'm thinking i should somehow combine the formula above with
=AND(EXACT(A1,C1),AND(EXACT(A1,E1)))
but I havent been able to. Can someone please help me?
I use the formula below to compare two values as long as they are not blank
=IF(AND((A1<>""),(C1<>"")),EXACT(A1,C1),"-")
However, I need to compare the value in A1 against other cells within the same formula as long as none are blank
I'm thinking i should somehow combine the formula above with
=AND(EXACT(A1,C1),AND(EXACT(A1,E1)))
but I havent been able to. Can someone please help me?
Related:
- Exact if not blank
- Facebook page blank ✓ - Facebook Forum
- Discord blank name ✓ - Internet & Social Networks Forum
- Tiktok blank page - TikTok Forum
- The internet is blank ✓ - Internet & Social Networks Forum
- Different dates of "end to end encryption message" on blank chat? - Internet & Social Networks Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 13, 2011 at 11:14 AM
Jun 13, 2011 at 11:14 AM
How about some thing like this
=IF(OR(A1="", C1="", E1=""),"-",AND(EXACT(A1,C1),EXACT(A1,E1)))
or may be even
=IF(A1="","-",AND(EXACT(A1,C1),EXACT(A1,E1)))
=IF(OR(A1="", C1="", E1=""),"-",AND(EXACT(A1,C1),EXACT(A1,E1)))
or may be even
=IF(A1="","-",AND(EXACT(A1,C1),EXACT(A1,E1)))