Forum Discussion
BrianSeymour
2 years agoQrew Cadet
This formula may be potentially simplified by removing the "and ranges" which also guards against edges cases.
For example, 1 year is 365 Days, so 0.01 year presents a 3.65 day window the initial formula which may produce unexpected results?
Consider this logic too!If (
[Years Employed] > 10.00, 20
[Years Employed] > 8.00, 15,
[Years Employed] > 3.00, 10,
[Years Employed] > 0.75, 5,
// Default
0
)
Or consider refactoring to using the Case formula too.
------------------------------
Brian
------------------------------