If/Then Help

Copper Contributor

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%


1 Reply
= IF(threshold<100%, 35%, 8%) * clientLifeSize