A Simpler Way

[DS]

Is there a impler way to do this? I need to get the Tax Amount for items
that are Tax Inclusive, Tax Exclusive and after discounts when needed. Any
help or direction appreciated.
Thanks
DS

'Figure Out Tax
Tax Before Discount
Exclusive
(Quantity * Price)* [TaxRate]
Inclusive
(Quantity * Price)-(Quantity * Price)/(1+[TaxRate])

Tax After Discount
Exclusive
Select Case DP ' Dollar or Percent Discount
Case 1
(Quantity * Price)+(Quantity * DiscountAmount) * [TaxRate]
Case 2
((Quantity * Price)*DiscountPercent)-(Quantity * Price) * [TaxRate]
End Select

Inclusive
Select Case DP
Case 1
(Quantity * Price)/(1+[TaxRate]+(Quantity *
DiscountAmount)*[TaxRate]
Case 2
(Quantity * Price)/(1+[TaxRate])*DiscountPercent-(Quantity *
Price)/(1+[TaxRate])*[TaxRate]
End Select


Just for argumants sake
Price is $5.00
Exclusive Price is $5.00
Inclusive Price is $5.00 / (1+[TaxRate])
Tax is .0825