Forum Discussion
jackthfc89
Feb 09, 2022Copper Contributor
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 ...
JoeUser2004
Feb 09, 2022Bronze Contributor
jackthfc89
Feb 09, 2022Copper Contributor
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?
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?
- HansVogelaarFeb 09, 2022MVP
Have you tried it?