Calculating Percentages on different total, then adding

Brass Contributor

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 have the percent discount in K70 applied to it. Then those two discounted subtotals are added.

 

This is what I have but it isn't working

=M64*(1-I70),+,IF(ISNUMBER(M68),M68*(1-K70)))

1 Reply

@erin-5304 

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)