If statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Danita said:
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
Click to expand...

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

Frank
 
Back
Top