Apr 21 2022 09:08 AM
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)))
Apr 21 2022 09:16 AM
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)