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

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?

Exact if not blank
Blank white square ✓ - Monitor Forum
Blank facebook page ✓ - Facebook Forum
If cell is zero then blank - Excel Forum
Messenger is blank white screen pc - Facebook Forum
Website loads but is blank ✓ - Network Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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)))

Similar discussions

Formula to Find&replace blank cells in excel

My Facebook Page is Loading Blank

blank Facebook white screen

after logging into Facebook it shows blank page

Cannot login to facebook, only get blank page

Similar discussions

Subscribe To Our Newsletter!