If then statement

[jfd1985]

Can someone write the If then function for this below.

Let's say the cell I am referring to is C3

[FONT=&quot]If cell equals 120-180 then 3[/FONT]
[FONT=&quot]If cell equals 100-119 or 181-220 then 2[/FONT]
[FONT=&quot]If cell equals 80-99 or 221-300 then 1[/FONT]
[FONT=&quot]If cell <80 or >300 then 0

I've tried embedded If statements and just can't get it to work.[/FONT]

 

[AliGW]

Try this:

=LOOKUP(C3,{0,80,100,120,181,221,301},{0,1,2,3,2,1,0})

 

[jfd1985]

AMAZING!!! Thanks so much!

 

[AliGW]

You're welcome!