# This might be simple

#### Supersats

##### New Member
Hi,

This might be simple, but I am approaching two months of writing spreadsheets and my head is failing

If Column A has a value of 9.1234, I want to round this, which I can do by various methods to the nearest whole number of 9. However, if I want to use the value in column A, I want to use the rounded version of 9 to complete further calculations, and not 9.1234.

Any ideas?

Many thanks, your help has been invaluable

### Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

=round(A1,0)/3

#### Supersats

##### New Member

=round(A1,0)/3
Thanks, but this rounds the number to the nearest whole and divides by 3? So 9.1234 becomes 3, when I want it to become 9 and stay at 9?

#### gaz_chops

##### Well-known Member
Then I don't follow! Give some examples of what you're trying to do.

P.s. the =round(A1,0)/3 was just showing how to use 9 in another calculation.

#### Supersats

##### New Member

The data I am using produces two scores, using a Z score method, an example is 46.573 and 56.72. However, I need to add the two scores of 47 and 57 to produce a total of 104. If I add the two cells as they are (even though they show as 47 and 57), I get 103.293, which obviously doesn't round to what I need to use

#### gaz_chops

##### Well-known Member
So like i said, use

=round(A1,0)+round(B1,0)

#### Supersats

##### New Member
Thank you. I don't know why this didn't work previously, but thank you anyway

#### gaz_chops

##### Well-known Member
You're welcome, glad you got it working.

Replies
7
Views
348
Replies
3
Views
80
Replies
0
Views
348
Replies
28
Views
900
Replies
4
Views
122

1,141,606
Messages
5,707,360
Members
421,503
Latest member
Rickys03

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