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
Different dates of "end to end encryption message" on blank chat? - Excel Forum
Discord blank name ✓ - Internet & Social Networks Forum
An example of a cell is a blank cell ✓ - Programming Forum
Tiktok blank page - TikTok Forum
The internet is blank ✓ - Internet & Social Networks 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

encryption message several time in chat

IF statements with dates and criteria

blank white page for website

using web browser page loads but screen blank

My Facebook Page is Loading Blank

Similar discussions

Subscribe To Our Newsletter!