Compare Two columns

J

JavyD

Hello,

I tried to figure this out, seems to me that I'm getting close

I need the formula to look at column AA see if it says O or U, then look at
Column AB and see if it says O or U, then if they both meet this criteria,
then return 1 in AC,

this is what I have so far,

=IF(OR(AA26={"O","U"},AB26={"O","U"}),"1",""), I'm probably off, but it
seems to have started to do something. I was using the And function, but
running out of time.

Regards, thanks to all in advance.
 
M

Marcelo

Hi Javy

try it

if(and((aa12="O");(ab12="O"));1;if(and((aa12="U");(ab12="U"));1;if(and((aa12="O");(ab12="U"));1;if(and((aa12="U");(ab12="O"));1;""))))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"JavyD" escreveu:
 
T

Trevor Shuttleworth

One way:

=IF(AND(OR(AA26="O",AA26="U"),OR(AB26="O",AB26="U")),"1","")

Regards

Trevor
 
J

JavyD

Thanks Marcelo, Thanks Trevor, Trevor's hit it right on the nail. it looks
the original I was working on, but I had the or trying to pick up the
AA26="O" or "U" together, I see you broke it apart.

Thanks both, this will make life easier.
 
T

Trevor Shuttleworth

You're welcome. Thanks for the feedback


JavyD said:
Thanks Marcelo, Thanks Trevor, Trevor's hit it right on the nail. it
looks
the original I was working on, but I had the or trying to pick up the
AA26="O" or "U" together, I see you broke it apart.

Thanks both, this will make life easier.
Click to expand...
 
Top