IF take 2 (ROUNDING)

G

Guest

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

Guest

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
 
S

Sandy Mann

Ron,

Why not just:

=CEILING(A1,0.25)

--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What do these numbers mean in the rounding formula? 2
advice on rounding or ceilng a 24 hour time value 3
Rounding decimals up or down 3
Can MROUND be used to always round down? 4
Rounding 6
Format cell to the nearest 100 4
Round formula 1
Rounding to the nearest cent...currency values 3

Top