Hi

=20(1+7.75%)
=20*7.75%/(1+7.75%)


Arvi Laanemets


"Lani Jo" <Lani Jo@discussions.microsoft.com> wrote in message
news:77E87ADB-A478-4245-9183-81225C3FF999@microsoft.com...
> Hello All,
>
> The situation is this...
>
> When given a new product, the user is given the price to a customer
> which includes sales tax. This number is typically a simple number such
as
> 50.00 or 20.00.
>
> The issue is that the *system* requires that retail price and sales tax
are
> entered separately, such as Retail Price 18.56 + Sales Tax 1.44 = Total
Price
> 20.00.
>
> While I know I learned this reverse calculation somewhere in past, I
cannot
> remember it now, which is preventing me from creating the formula.
>
> Please help.
> Thanks in advance.
>
> Lani