Roundup
 

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

Roundup
 

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

Roundup
 

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.

Roundup
 

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

Roundup
 

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

Roundup
 

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