Changing Excel Decimal Calculations from .99 to .60

[leena671]

I am trying to calculate a huge number of decimal numbers but I need excel to calculate it in a certain way and I can't seem to get it right...

Here is an example of what I want...

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 place going up to .99, I want it to only go up to .60...

I hope someone can help me...I'm kind of on a crunch!

Thanks a MILLION!

 

[jeffreybrown]

If you choose to x-post please post a link to your previous post...it may help

http://www.excelforum.com/excel-general/746366-calculating-decimals.html#post2385942

 

[Mr_Roscoe]

I have replied on the other post

PS you owe me a million, I accept gold, bearer bonds, Euros, US$, PayPal and major credit cards. Or you could just find my other lost sock.....

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=496172

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted:
http://www.mrexcel.com/forum/showthread.php?t=127080

If you have posted to the wrong forum if error, please use the Report button to ask a Moderator to move instead of posting the question again.