Conditional Discount formula
 

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 A55:D55. Thanks to
whoever can HELP!!!
--
Nick

Conditional Discount formula
 

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

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(A55:D55))


--
Regards,
Tom Ogilvy

"Nick" wrote:

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 A55:D55. Thanks to
whoever can HELP!!!
--
Nick

Conditional Discount formula
 

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" wrote:

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

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(A55:D55))


--
Regards,
Tom Ogilvy

"Nick" wrote:

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 A55:D55. Thanks to
whoever can HELP!!!
--
Nick

Conditional Discount formula
 

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.

--
Regards,
Tom Ogilvy



"Nick" wrote in message
...
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" wrote:

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

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(A55:D55))


--
Regards,
Tom Ogilvy

"Nick" wrote:

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 A55:D55.
Thanks to
whoever can HELP!!!
--
Nick