If less than, OR between, OR greater than - return X value

[jackthfc89]

Hallo!

I need help big time, 

Effectively I need to create a formula for:

If column C value is less than 2.0 populate value "A1" (this is text not a cell reference"

If column C value is less than 5.0 but greater than 1.9 populate value "A2" (same same)

If column C value is greater than 4.9 populate value "A3" (you get this gist)

Might help to consider Column C as employee length of service and A1, A2 and A3 as their benefit package descriptor.

E.g

A1 new starters, up to 2 years

A2 settled employees, 2 to 5 years

A3 legacy employees 5 years + service

Any help will be much appreciated!

[#2]

@jackthfc89 

Perhaps:

=IF(C2="", "", LOOKUP(C2, {0, 2, 5}, {"A1", "A2". "A3"}))

[#3]

Thank you Joe, think I've left some crucial intel out here!
The employee length of service is very rarely exact numbers, it's rounded to 1 decimal point e.g.
0.1
0.2
0.3
all the way to about 30 years

I'm not sure this would still work?

[#4]

@jackthfc89 

Have you tried it?