Roundup

[Dennis1188]

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

 

[T. Valko]

Maybe this:

=FLOOR(A1,0.05)+0.05

Biff

 

[joeu2004]

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.

 

[john]

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)

 

[Jim Thomlinson]

One way...

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

 

[Dennis1188]

PERFECT!!
Thanks

One way...

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