Forum Discussion

jackthfc89's avatar
jackthfc89
Copper Contributor
Feb 09, 2022

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

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!

excel
Formulas and Functions
office 365

3 Replies

    • jackthfc89's avatar
      jackthfc89
      Copper Contributor
      Feb 09, 2022
      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?

Resources