Forum Discussion
Ahornsnby11813
Oct 17, 2023Copper Contributor
If/Then Help
Hello,
I am trying to generate a formula to help with calculations. Basically, I am looking for
L2 is threshold
E2 is client life size
If L2 is less than 100% then *E2 by 3.5%
IF L2 is = to 100% then *E2 by 8%
- PeterBartholomew1Silver Contributor
= IF(threshold<100%, 35%, 8%) * clientLifeSize