View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 698
Default IF take 2 (ROUNDING)

Try this:

With a number in A1

This formula rounds that number up in multiples of 0.25
B1: =CEILING(A1/0.25,1)*0.25

Does that help?
***********
Regards,
Ron

XL2003, WinXP


"Neil Pearce" wrote:

In the questing below what I'm really asking I suppose is how do you round a
number up to the nearest 0.25?