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

@johnsbox 

=E2*0.17-IF(ISNUMBER(K2),K2*0.17,0)-IF(ISNUMBER(L2),L2*0.17,0)

You can try this formula.

multiplication and if.JPG