Oct 17 2023 09:25 AM - edited Oct 17 2023 09:39 AM
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%
Oct 17 2023 11:34 AM
= IF(threshold<100%, 35%, 8%) * clientLifeSize
