Link to home
Start Free TrialLog in
Avatar of coonasty
coonasty

asked on

help with an excel problem

im very simply trying to sum up 4 numbers in a spreadsheet.  and no matter how i do it.  excel does not add them up correctly.

if you look at the picture im trying to have excel sum up 3+11.69+2.73+4.  excel for some reason wants to say the answer is 21.19.  it obviously is not.  how the heck do i make this thing add correctly?

TIA
excel1.jpg
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

It's probably a matter of rounding in that the display value of the individual fields is greater than or less than the actual value. Can you supply a sanitized workbook?
Avatar of coonasty
coonasty

ASKER

ah ur right the 4 is actually a rounded up figure from 2 decimal places.  so the sum is adding 3.77 instead of the 4 that is in the last box.  how would i override and tell it to add 4 instead of 3.77?  TIA
I'm not sure but try formatting as Currency (without a monetary symbol like $).
If that doesn't work please supply a workbook that just has a few rows (including row 9) formatted like your real workbook and with sensitive data removed.
here is the example sheet.
test-sheet1.xlsx
Why are not M9 and M10 in your picture formatted as numbers with 2 decimal places like the others in that column? If M( showed 3.77 the calculation in N9 would be correct.
M9 must be rounded to a whole number with no decimals.  the figure can not be 3.77 or yeah this would be done and ez.  it must be the whole number 4.  therefore N9 must be added with the 4 and not 3.77.  but even though M9 shows the whole number 4, N9 is totalled using 3.77 from M9.  

Need to overide that and tell it to use the whole number 4.  I know M9 is calculated using 2 decimal places.  but the answer must be rounded to a whole number.  thanks much
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
that did it!   thanks so much.  ive been looking all over the web for the code to fix.
You're welcome and I'm glad I was able to help.

If you expand the “Full Biography” section of my profile you'll find links to some articles I've written that may interest you.

Marty - Microsoft MVP 2009 to 2016
              Experts Exchange MVE 2015 and 2016
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2016