MrExcel Publishing
Your One Stop for Excel Tips & Solutions

not adding values up right


Posted by daniel on February 07, 2002 7:18 PM

here is my formula to figure my uan solution

sum(c1*d1,e1*f1) this works but when the column sums up the total is .001 less (driving me crazy)


Posted by Yogi Anand on February 07, 2002 7:58 PM

Hi Daniel:
Have you tried formatting the cell with the result to a larger number of decimal places. How about posting the numbers in C1,D1,E1,F1, and your result for reference.
HTH

Yogi Anand
ANAND Enterprises (broken link)

Posted by Computerfreaks on February 08, 2002 2:43 AM

If that doesn't works then add +0.001 to the end of the formula!!