# Calculations and Decimal Places

#### claire publishing

##### New Member
Hello

Sorry if this is a very basic problem and myself and nobody in my office can work this out.

I am wanting to know how I can make excel do its calculations based on the numbers as the appear on the screen (to the number of decimal places that I have selected in format cells) not the number of decimal places that may have been entered or generated.

For example:

How do I make

\$17.156
+ \$18.156
(which would appear as \$17.16 + \$18.16)
calculate to \$35.32 not \$35.31

Hope this makes sense? Any help would be most appreciated.

Claire

### Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Welcome to the Board!

You could use the CEILING() function:

=CEILING(17.156+18.156,0.01)

or use ranges instead of hardcoding the numbers. Hope that helps!

Thanks TazGuy. Any suggestions how I get this function to apply to a whole work sheet?

Depends how your data is laid out. Here's an example:
Book1
ABCD
10.2036820.79891.01
20.2869960.9041931.2
30.250860.705940.96
40.8830560.770561.66
50.7219790.8176881.54
60.541860.2810640.83
70.4179890.8541091.28
80.1142090.9879751.11
90.2012810.1561950.36
100.5101260.8801851.4
110.8369480.8945751.74
120.3629650.3694280.74
130.1257670.3848810.52
140.8899470.049860.94
150.3521880.0076510.36
160.0315440.2214460.26
170.9331040.7438881.68
Sheet2

Formula in C1 (copied down) is:
=CEILING(A1+B1,0.01)

See how that's working? Post back if you have more questions.

Check the option Precision As Displayed on the Calculation tab under Tools|Options.

Replies
8
Views
147
Replies
7
Views
261
Replies
4
Views
173
Replies
0
Views
143
Replies
3
Views
201

1,203,347
Messages
6,054,878
Members
444,760
Latest member
TeckTeck

### 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.

### Which adblocker are you using?

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

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