Excel 2007 : Formula does not give correct Total.

**msladona** · 01-29-2010, 11:31 PM

I cannot get my formula to come up with the correct amount. I should say 2,296 but is says 2,299. I have attached a copy of the spreadsheet I am working with. Any help would be greatly appreciated. Thanks,

**Ron Coderre** · 01-29-2010, 11:41 PM

Cell D14 does NOT exactly equal its displayed value.
It equates to 2.673783
but displays 2.67

You'd need to change the formula in C15 to:

Please Login or Register  to view this content.

Is that something you can work with?

**martindwilson** · 01-30-2010, 10:03 AM

i also notice a strange use of sum() i.e =SUM(C4*C5) altho' it wont fix anything its not neccessary
=c4*c5 is sufficient!
similarly
SUM(C11+F11) could be just be =C11+F11 or even =SUM(C11,F11)

**msladona** · 01-30-2010, 03:18 PM

Ron - This worked perfect. I am do not understand the (D12,2) could you explain to me what that is? When you say [SIZE="2"] are you talking decimals? Thanks for your help.

Originally Posted by Ron Coderre

Cell D14 does NOT exactly equal its displayed value.
It equates to 2.673783
but displays 2.67

You'd need to change the formula in C15 to:

Please Login or Register  to view this content.

Is that something you can work with?

**Ron Coderre** · 01-30-2010, 03:50 PM

Originally Posted by msladona

Ron - This worked perfect. I am do not understand the (D12,2) could you explain to me what that is? When you say [SIZE="2"] are you talking decimals? Thanks for your help.

The ROUND(D12,2) section simply rounds the value from cell D12 to 2 decimal places.
so
...if D12 contained: 1.33333333333
...the above function would round that value to: 1.33

Regarding : [SIZE="2"]
That is just an HTML formatting code in the quoted text that
tells the forum to display font size: 2...which is larger than
the normal font (and less strain on my eyes). It doesn't
display and is NOT part of my response.

I hope that helps.