If A1 or A2 contains X

**MetteGaga** · 06-09-2016, 05:31 AM

Hi,

I have a file where i would like a formula in a3 which writes a 0 if A1 og A2 contains and X, if none of them conatains X then A3 should say 1.

Can anyone help me ?

thanks in advance

**Crooza** · 06-09-2016, 05:46 AM

Is this what you want?

=if(or(A1="X",A2="X"),0,1)

**Phuocam** · 06-09-2016, 05:47 AM

Try ...

=--(COUNTIF(A1:A2,"X")=0)

**MetteGaga** · 06-09-2016, 06:00 AM

Crooza: thanks that on works perfektly

**Crooza** · 06-09-2016, 07:15 PM

Great. Glad it worked

If A1 or A2 contains X

LinkBack

Thread Tools

Rate This Thread

Display

If A1 or A2 contains X

Re: If A1 or A2 contains X

Re: If A1 or A2 contains X

Re: If A1 or A2 contains X

Re: If A1 or A2 contains X

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions