Using the multiple formulas (One being Multiplication the other being IF

Copper Contributor

So I want to have cell F2 Multiply E2*17% but then also IF K2 has a total of $30(or any number) in it  to deduct 17% of $30 from F2 and if another cell L2 has $40(or any number) in it to deduct 17% of $40 from the total in F2 as well

1 Reply



You can try this formula.

multiplication and if.JPG