How can I round up to get these results:

13.30 13.35
13.34 13.35
13.36 13.40
13.38 13.40

Maybe this:

=FLOOR(A1,0.05)+0.05

Biff

"Dennis1188" wrote in message
...
How can I round up to get these results:

13.30 13.35
13.34 13.35
13.36 13.40
13.38 13.40

On Mar 6, 11:19 am, Dennis1188
wrote:
How can I round up to get these results:
13.30 13.35
13.34 13.35
13.36 13.40
13.38 13.40

Rounding 13.30 to 13.35 seems unusual, especially since 12.36 and
12.38 would presumably round to 13.30, following the examples for
13.36 and 13.38.

If you still on insist on rounding 13.30 to 13.35, we should ask:
what should 13.35 round to?

The "obvious" choice is 13.35; but you did not choose the "obvious"
choice for 13.30.

try =CEILING(A1,0.05)
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Dennis1188" wrote:

How can I round up to get these results:

13.30 13.35
13.34 13.35
13.36 13.40
13.38 13.40

One way...

=ROUND((A1 + 0.025 )/ 0.05, 0)*0.05
--
HTH...

Jim Thomlinson


"Dennis1188" wrote:

How can I round up to get these results:

13.30 13.35
13.34 13.35
13.36 13.40
13.38 13.40

PERFECT!!
Thanks



"Jim Thomlinson" wrote:

One way...

=ROUND((A1 + 0.025 )/ 0.05, 0)*0.05
--
HTH...

Jim Thomlinson


"Dennis1188" wrote:

How can I round up to get these results:

13.30 13.35
13.34 13.35
13.36 13.40
13.38 13.40