formula will not add up right

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kickstart - 11 Apr 2006 15:30 GMT

I put in =sum(E1+G23) & the total in the cell where I put the formula comes
up(2 or 3) cents off? It comes up short when I put =sum(E1*G23). Not al the
time but off & on. I have to add stuff on paper to check that the total is
right. I should not have to take all this time to use Excel.

Reply to this Message

Niek Otten - 11 Apr 2006 15:35 GMT

Your question has already been answered an hour and a half ago

Signature

Kind regards,

Niek Otten

>I put in =sum(E1+G23) & the total in the cell where I put the formula comes
> up(2 or 3) cents off? It comes up short when I put =sum(E1*G23). Not al the
> time but off & on. I have to add stuff on paper to check that the total is
> right. I should not have to take all this time to use Excel.

Reply to this Message

JE McGimpsey - 11 Apr 2006 15:36 GMT

Check out

http://www.mcgimpsey.com/excel/pennyoff.html

Note that you don't need the SUM() functions.

=E1+G23
=E1*G23

work the same way.

> I put in =sum(E1+G23) & the total in the cell where I put the formula comes
> up(2 or 3) cents off? It comes up short when I put =sum(E1*G23). Not al the
> time but off & on. I have to add stuff on paper to check that the total is
> right. I should not have to take all this time to use Excel.

Reply to this Message