Crosswords1 min ago
Formulas for excel
1 Answers
I am trying to make up a timesheet in excel but need the formulas to round the hours up or down. Any ideas??
Answers
Only 1 answer
Best Answer
No best answer has yet been selected by giggles321. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
excel has three commands
ROUND
ROUNDUP
ROUNDDOWN
so to get cell b1 to display and round the contents of cell a1 would be
=ROUND(a1,1)
Would display contents of cell a1 rounded to one decimal place
or to round a sum would be
=ROUND(77/3,2)
would display 77/3 rounded to 2 decimal places
The number after the comma is the number of decimal places you want to round to, 0 being no decimal places.
ROUNDUP and ROUNDDOWN are used in the same way but will round in the direction stated.
Google excel round command for more help, though not sure how it will work with time, I hate dealing with time in excel :)
ROUND
ROUNDUP
ROUNDDOWN
so to get cell b1 to display and round the contents of cell a1 would be
=ROUND(a1,1)
Would display contents of cell a1 rounded to one decimal place
or to round a sum would be
=ROUND(77/3,2)
would display 77/3 rounded to 2 decimal places
The number after the comma is the number of decimal places you want to round to, 0 being no decimal places.
ROUNDUP and ROUNDDOWN are used in the same way but will round in the direction stated.
Google excel round command for more help, though not sure how it will work with time, I hate dealing with time in excel :)
Only 1 answer
