This might be simple

Supersats

New Member
Joined
Jan 30, 2013
Messages
43
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
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

gaz_chops

Well-known Member
Joined
Apr 29, 2003
Messages
6,468
Platform
  1. MacOS
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
Joined
Jan 30, 2013
Messages
43

ADVERTISEMENT

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
 

Watch MrExcel Video

Forum statistics

Threads
1,123,337
Messages
5,601,026
Members
414,422
Latest member
acegreen

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
Top