28th April 2005, 03:46 PM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 4,415
|
|
Quote:
|
Originally Posted by DR RON
While on the subject could somebody please help me with the following problem.
In a spreadsheet in cell A1 I have a figure, in cell A2 I want to divide the figure in A1 by 11.5 and then round up or round down the answer to the nearest .25
for example 52.4322 i want to become 52.5 52.8976 I want to become 53 52.2134 I want to become 52.25 ecetera . could some body please supply the formula I need for A2 or does the rounding need to be done in the next cell ?
Thanks
|
Hi Doc,
Format cell A2 (or any others used in your weight answer) as number with two decimal places.
Then type into cell A2
=MROUND(A1/11.5,0.25)
I have only run it on a few examples...it should work fine.
If you get an answer which is #VALUE!, then make sure you have all the addins installed for Excel. |