| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tax % in a cell
The sub-total which is the taxable amount is in K27, but when I do the
formula you gave me K27*.0775= it gives me the wrong amount. Sorry for not understanding. Debe Sub-Total $27.00 Shipping $4.50 Tax K27*.0775= gave me like 20.00. HELP! Deposit Final Balance $31.50 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Tax % in a cell
Check the decimal position in .0775. The multiplying $27 by .0775 produces a
result of 2.0925 -- Kevin Backmann "Debe" wrote: The sub-total which is the taxable amount is in K27, but when I do the formula you gave me K27*.0775= it gives me the wrong amount. Sorry for not understanding. Debe Sub-Total $27.00 Shipping $4.50 Tax K27*.0775= gave me like 20.00. HELP! Deposit Final Balance $31.50 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Tax % in a cell
Go to Tools--Options--Edit and make sure Fixed decimal is not selected.
Click OK, and then press F9 to recalculate. Does that work? -- Brevity is the soul of wit. "Kevin B" wrote: Check the decimal position in .0775. The multiplying $27 by .0775 produces a result of 2.0925 -- Kevin Backmann "Debe" wrote: The sub-total which is the taxable amount is in K27, but when I do the formula you gave me K27*.0775= it gives me the wrong amount. Sorry for not understanding. Debe Sub-Total $27.00 Shipping $4.50 Tax K27*.0775= gave me like 20.00. HELP! Deposit Final Balance $31.50 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Tax % in a cell
$27.00*0.0775 gave me $2.09 (but * 0.775 will give $20.09). Are you sure the
% factor is right? "Debe" wrote: The sub-total which is the taxable amount is in K27, but when I do the formula you gave me K27*.0775= it gives me the wrong amount. Sorry for not understanding. Debe Sub-Total $27.00 Shipping $4.50 Tax K27*.0775= gave me like 20.00. HELP! Deposit Final Balance $31.50 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| up to 7 functions? | Excel Worksheet Functions | |||
Linear Mode
