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 ...
excel
Formulas and Functions
office 365
JoeUser2004's avatar
JoeUser2004
Bronze Contributor
Feb 09, 2022

jackthfc89 

 

Perhaps:

 

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

 

  • 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