ExcelBanter - % in a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - % in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/108545-%25-cell.html)

Debe

% in a cell

Sub-Total $27.00
Shipping $4.50
Tax $20.93
Deposit

Final Balance $52.43

Toppers

% 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

Dave F

% 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

All times are GMT +1. The time now is 10:42 PM.