Finding the value of x
$1000 represents the original amount plus tax, i.e. 1.055 x original
amount. Thus, original amount =$1000/1.055, or in Excel terms if the
invoice is in A1:
=A1/1.055
giving $947.867.
Hope this helps.
Pete
On Jul 26, 3:44 pm, bpiepkorn
wrote:
I need to find the value of x for the following equation. The total of the
invoice is $1,000, but I need to find how much the original dollar amount was
without tax. The tax is 5.5% and is included in the total of $1,000. How
would a formula in excel be set up to be able to find out the original value
of the invoice without tax? The invoice will still need to equal $1000.00,
but I need to find the original number.
|