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.

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!!