Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding the value of x
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding the value of x
try this where e14=.055
=1000/(1+E14) -- Don Guillett Microsoft MVP Excel SalesAid Software "bpiepkorn" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding the value of x
Assume that the $1000 is in cell A1
=A1/1.055 will give you the original invoice amount ($947.87 [.8673 to be more precise]) You can validate this with this formula =1.055 * 947.87 turns out to be 1000.003, which will appear in currency format as $1000.00 If you had the interest in a cell, A2 for example, in percent format then you could change the 1st formula to: =A1/(1+A2) "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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding the value of x
=A1/1.055
-- -John Please rate when your question is answered to help us and others know what is helpful. "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding non-zero value | Excel Discussion (Misc queries) | |||
Finding Max or Min Value | Excel Discussion (Misc queries) | |||
Finding Row | Excel Discussion (Misc queries) | |||
Finding last used | Excel Worksheet Functions | |||
Finding Value | Excel Worksheet Functions |