Excel Rounding

[A[L]C]

Hi all,

=ROUNDUP((G8/4),0)

If G8 = 8

I would expect this to keep it at 2 but it returns 3.

We get paid in 4 hour chunks, so if we work 6 hours, we get paid for 8. If we do 8, we get paid for 8, if we do 9 we get paid for 12.

Can anyone shed some light?

Thanks

 

[Participant]

Hi all,

=ROUNDUP((G8/4),0)

If G8 = 8

I would expect this to keep it at 2 but it returns 3.

We get paid in 4 hour chunks, so if we work 6 hours, we get paid for 8. If we do 8, we get paid for 8, if we do 9 we get paid for 12.

Can anyone shed some light?

Thanks

All I can tell you is that in my Excel (2007 fwiw), the result is indeed 2.

 

[Abooie]

I get 2 as well.

Try =ROUNDUP(G8/4,0)*4 to round up too.

 

[A[L]C]

Hmmm

Can you take a look

http://paulharman.fmguy.com/Overtime Claim Form ocuk.xlsm

 

[A[L]C]

Ahh its not 8...

Its 8.00000000005821

But I dont understand why

I guess i need to do something like this?

=ROUNDUP((ROUND(G8,0))/4,0)

 

[Participant]

Ahh its not 8...

Its 8.00000000005821

But I dont understand why

I guess i need to do something like this?

=ROUNDUP((ROUND(G8,0))/4,0)

Sounds good.