
28th April 2005, 03:10 PM
|
Member
|
|
Join Date: Jan 1970
Location: victoria
Posts: 562
|
|
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
|