Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
% in a cell
Sub-Total $27.00
Shipping $4.50 Tax $20.93 Deposit Final Balance $52.43 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
% in a cell
See previous replies : this post suggests you multiplied by 0.775 not 0.0775.
"Debe" wrote: Sub-Total $27.00 Shipping $4.50 Tax $20.93 Deposit Final Balance $52.43 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
% in a cell
How are you entering the 7.75%? Are you entering it in decimal form (0.0775)
or are you entering 7.75? If you're entering 7.75 and have fixed decimal selected in your Options, that may account for multiplying by 0.775 and not 0.0775. -- Brevity is the soul of wit. "Toppers" wrote: See previous replies : this post suggests you multiplied by 0.775 not 0.0775. "Debe" wrote: Sub-Total $27.00 Shipping $4.50 Tax $20.93 Deposit Final Balance $52.43 |
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 |