If statements

[Danita]

I need to create a formula that in words says

If cell a1 = 80 then put 7, if a1 = 120 = then put 10, if a1=160, then put 1

I can't figure out for 3 options, versus
Help me

 

[Frank Kabel]

I need to create a formula that in words says:

If cell a1 = 80 then put 7, if a1 = 120 = then put 10, if a1=160,
then put 13

I can't figure out for 3 options, versus 2
Help me

Hi Danita
try
=IF(A1=80,7,IF(A1=120,10,IF(A1=160,13,"")))

Frank

 

[Peo Sjoblom]

Try

=VLOOKUP(A1,{80,7;120,10;160,13},2,0)

 

[Danita]

Thanks Frank it worked.