Rounding Decimals

[jujuwillis]

Help, I am trying to calculate a holiday pay table. I'm fine until I
come to round up or down the days the formula is below. as I want then
to calculate the number of whole days only, not the 16.56 , but 17

No of Weeks worked/No of Weeks in year * Allocation

(42/52*21) = due holidays (in this case 16.56)

I want to be able to round up anything over .50 to the next integer and
round down anything under .49 to the next integer, to enable me to
calculate the pay (for whole days only).

I have tried different calculations for hours and I'm probably just
missing a bit of logical thinking on my part - but I'm not being
logical today.

 

[Peo Sjoblom]

=ROUND(42/52*21,0)

or probably

=ROUND(A1/B1*C1,0)

where the cells hold the values

 

[jujuwillis]

Thanks, that's excellent - worked a treat, why I could "get it"
yesterday I don't know.