# Calculating Decimals

1. ## Calculating Decimals

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  Register To Reply

2. ## Re: Calculating Decimals

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

3. ## Re: Calculating Decimals

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  Register To Reply

4. ## Re: Calculating Decimals

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

5. ## Re: Calculating Decimals

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...  Register To Reply

6. ## Re: Calculating Decimals  Register To Reply