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
- jackthfc89Feb 09, 2022Copper ContributorThank 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?- HansVogelaarFeb 09, 2022MVP
Have you tried it?