IF take 2 (ROUNDING)
 

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

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?

IF take 2 (ROUNDING)
 

Ron,

Why not just:

=CEILING(A1,0.25)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Ron Coderre" wrote in message
...
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?

IF take 2 (ROUNDING)
 

Why? I'll tell you why....
Because I hadn't had my morning coffee yet. That's why. <vbg

(Your formula is better)

***********
Regards,
Ron

XL2003, WinXP


"Sandy Mann" wrote:

Ron,

Why not just:

=CEILING(A1,0.25)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Ron Coderre" wrote in message
...
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?