Changing Excel Decimal Calculations from .99 to .60

Status
Not open for further replies.
L

leena671

New Member
Joined
Sep 20, 2010
Messages
3
:confused: 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!
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Sort by date Sort by votes
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.....
 
Last edited:
Upvote 0
Upvote 0
Status
Not open for further replies.

Similar threads

J
  • Question
What changed with the Decimal Points
Replies
1
Views
295
6StringJazzer
6StringJazzer
F
  • Question
Calculating the average when not using whole numbers
Replies
3
Views
192
RoryA
RoryA
G
  • Question
IF function in Excel
Replies
2
Views
284
Gajendran Yadhav
G
S
  • Question
Trendline values using Dynamic Range in Excel - comparing with LINEST function
Replies
1
Views
211
Domenic
D
B
  • Question
Finding a way to swap column data based on calculated total limit
Replies
0
Views
290
bradgirman
B

Forum statistics

Threads
1,215,001
Messages
6,122,648
Members
449,092
Latest member
peppernaut

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top