G Guest Jul 20, 2007 #1 In the questing below what I'm really asking I suppose is how do you round a number up to the nearest 0.25?
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 Jul 20, 2007 #2 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
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 Jul 20, 2007 #3 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
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 Jul 20, 2007 #4 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
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
