Logic test with 2 conditions

I can get the same result when I put the formula in a column and stretch it across rows.

=IF(OR(CurrentRowCell="red";CurrentRowCell="");1;2)

And apply this formula to each row by dragging it down.

Thus you’ll have in row 1: =IF(OR(A1="red";A1="");1;2)
in row 2: =IF(OR(A2="red";A2="");1;2)
in row 3: =IF(OR(A3="red";A3="");1;2)
etc...

--
Always keep in mind to accept a post that gets you out of trouble

I showed you in image what I wanted because I tried the formulas that were put, they don’t work if I replace the numbers with names

[link=https://www.casimages.com/i/110922020859580453.jpg.html' target='_blank' rel='nofollow noopener noreferrer'>https://www.casimages.com/i/110922020859580453.jpg.html][img]http://nsa27.casimages.com/img/2011/09/22/mini_110922020859580453.jpg[/img][/url]

thank you

ok it works
thank you

We must use the AND operator and the IF formula combined. for the rest, your question already gives its own answer.

--
He is not a sales representative: he’s your dad!