I need and and/or statement
your welcom, have a great day
"soconfused" wrote:
Thank you, that works perfectly.
--
DMM
"Eduardo" wrote:
Hi,
in column B enter
=if(or(A1="13A",A1=20),1,0)
"soconfused" wrote:
I believe I am looking for an OR statement, but I need help.
In column A, I can have either "13A" or "20", if it's either of those two
numbers I want to put a 1 in column B, if it's not either of those numbers I
want to put a 0 in column B.
Can somebody help me write this formula.
Thanks in advance for your help
--
DMM
|