Thread: Excel Help
View Single Post
  #10  
Old 28th April 2005, 03:10 PM
DR RON DR RON is offline
Member
 
Join Date: Jan 1970
Location: victoria
Posts: 562
Question

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
Reply With Quote