Conditional Discount formula

[Guest]

Ok,
This is what i need to do...If a discount is applied in A57 then E55 will
reflect the following: apply the discount to A55 and then tax the new total
by 9.5%tax, apply the discount then to C55 and then tax that new total by
11.75% and then finnally adding the 2 new totals together for a Grand Total,
but if no discount is applied it is a simple formula of A5555. Thanks to
whoever can HELP!!!

 

[Guest]

=if(A57<>"",(A55*A57)*1.095+(C55*A57)*1.1175),Sum(A5555))

if you want to add in B55 and D55 in the first case:

=if(A57<>"",(A55*A57)*1.095+(C55*A57)*1.1175)+B55+D55,Sum(A5555))

 

[Guest]

Tom,
What this does not do is add the two subtotals together after the discount
and tax is applied to give me a grand total i.e. A55=200*10% discount then
subtract the discount from the total and then add the tax of 9.5% for a new
subtotal. Repeat that same equation with the same discount cell(A57) just a
different subtotal cell(c55). then add the 2 new subtotals together for a
grand total. But if there is no discount applied I just want it to add A55
thru C55.
Nick

 

[Tom Ogilvy]

If you put .9 in A57 it would do exactly what you ask.



=if(A57<>"",(A55-(A55*A57))*1.095+(C55-(C55*A57))*1.1175),A55+B55+C55))

Unless your interpretation of what a Tax is is different from mine, this
should do what you want.