Error in computed % as dollar amount

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
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.
 
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.
 
Back
Top