Forum Discussion
Calculating Percentages on different total, then adding
I am trying to write a formula for this situation: The Subtotal in M64 should have the percent discount in I70 applied to it, while simultaneously, if there is a number in M68, then it should hav...
Does this do what you want?
=M64*(1-I70)+IF(ISNUMBER(M68),M68*(1-K70),0)
or perhaps even
=M64*(1-I70)+M68*(1-K70)