Error in computed % as dollar amount

[Nancyg]

HELP - this is driving me insane - I have a spreadsheet where I need to
figure the dollar amount of a percentage - see if you follow this:

Cell : D1 = $100.00
G1 = 100.00%
H1 should be my answer - this is my formula:
=SUM(D1 * G1) -
MY ANSWER SHOULD BE $100.00 - BUT HALF THE TIME I GET $99.99 AND THE OTHER
HALF OF THE TIME ITS RIGHT - I HAVE THE "PRECISION AS DISPLAYED" OPTION
TURNED ON - READ EVERYTHING I CAN FIND ON ROUNDING ISSUES - CAN ANYONE,
PLEASE TELL ME WHAT I'M DOING WRONG?
THANKS IN ADVANCE FOR THE HELP!!

 

[Alojz]

In my understanding precision as displayed should be turned off to get
unrounded result. Why you write formula =sum(d1*g1) instead of =d1*g1 ?
However, I tried to simulate your issue and always get $100.00, so little
chance I can help.

 

[ShaneDevenshire]

Hi,

I'm in agreement with the previous email, don't set precision as displayed
and use =g1*d1 not SUM(g1*d1). But none of these should relate to the
problem you mention.

This error suggest that D1 or G1 is probably a formula, in which case there
could be unexposed digits. Select D1 and G1 and click the Increase Decimals
button a few times to check this out.