Rounding up and or down formula

  • Thread starter Thread starter Potaroo
  • Start date Start date
P

Potaroo

I'm after a formula that will give me the closest to a 0.25 incremental
ending.
That is if the sum ends up being 4.29, I need it to return a 4.25
If it ends up being 2.8 I need it ot return a 2.75.
If it ends up being 2.89 I need it ot return a 3.
Is there such a method?
TIA to all you Gurus.
Pete
 
Hi Potaroo,

=ROUNDUP(A1*4,0)/4
=ROUND(A1*4,0)/4
=ROUNDDOWN(A1*4,0)/4
will round the value in A1 to the nearest higher quarter, nearest quarter, or nearest lower, quarter, respectively.

Cheers
 
Bill,

Unless I am completely misunderstanding you:

In your example sheet formulas like:

=ROUND(B6,1.25)

is the same as =ROUND(B6,1)

That is it rounds to the nearest one decimal place. It does not round to
the nearest 1.25

Like wise =ROUND(B12,100) Rounds to the nearest 100 decimal places not the
nearest 100

--
HTH

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
You're reading it OK Sandy. I've spent some time today trying to get it
right. I'll look at it again tomorrow.

Regards.

Bill Ridgeway
Computer Solutions
 
Thanks fellas for your input in helping me out.
You fellas and all the others who help people with their problems are
indisensible to blokes like me.
Regards Pete
 
Back
Top