Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
2 years ago

Formula to calculate values - range of quantities

[ANNUAL PTO DAYS - ALLOWED] IF [YEARS EMPLOYED]<.75, 0, IF [YEARS EMPLOYED]>.7501 and less than 3.0, 5, IF [YEARS EMPLOYED]>3.01 and less than 8.0, 10, IF [YEARS EMPLOYED]>8.01 and less than 10,...