Calculating Decimals

**leena671** · 09-20-2010, 08:34 PM

I am trying to calculate decimals with a maximum of .60 insead of .99 and am having some trouble doing it.

here is an example of what I am looking for:

1.30
2.30

total: 4.00

If someone can please help me I would greatly appreciate it! Thank you!

**davesexcel** · 09-20-2010, 08:37 PM

Try this
=ROUND(SUM(A1:A2),0)
Assuming the values are in A1 and A2

**leena671** · 09-20-2010, 08:47 PM

It sort of works...

I have a total of 52 decimal numbers I need to add up and when I use that formula it only rounds the total up one.

For example, my total is 24306.90 when it should be 24311.30. Your formula is giving me 24307.00

The difference is because it is calculating the ".##" up to .99. I want it to calculate up to .60

**davesexcel** · 09-20-2010, 08:51 PM

Okay, well your example has 1.3 +2.3 and you wanted the answer to be 4.

**leena671** · 09-20-2010, 09:02 PM

Right.

You may have misunderstood me, I appologize. Here is another example:

1.45
2.20
3.15

Excel is calculating the above to be 6.80 and I want to to calculate as 7.20. Instead if the decimal going up to .99, I want it to only go up to .60...

I hope that clarify's things a little better...