I need an excel formula that if a number in cell A1 is 1,2 or 3 then put number 8 in cell A2. If not leave blank

Question

I need an excel formula that if a number in cell A1 is 1,2 or 3 then put number 8 in cell A2. If not leave blank.

I tried a bunch of formulas but I don't know what this one would be called. Sounds like a simple formula but I have alot to learn about Excel.

Answer 1

=IF(OR(A1=1, A1=2, A1=3), 8, "")

This formula checks if the value in cell A1 is 1, 2, or 3. If it is, it places the number 8 in cell A2. If it's not, it leaves cell A2 blank.

Answer 2

Try one of the following formula-

=IF((A1>=1)*(A1<=3),8,"")
=(A1>=1)*(A1<=3)*8

Answer 3

Since you mentioned that none of them worked, could you try this:

=IFERROR(IF(OR(0 + TRIM(A1) ={1,2,3}),8,""),"")

• In case of these are numbers surrounded by spaces, TRIM to strip them
• 0 + to convert to a number (-- is also used very often)
• IFERROR is to handle error from the previous step
• After getting a number, comparing it {1,2,3} results in TRUE/FALSE accordingly
• In the example below, numbers are entered as text in D1-F1