Forum Discussion

Ahornsnby11813's avatar
Ahornsnby11813
Copper Contributor
Oct 17, 2023

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%

 

Resources