Get instant live Excel expert help to learn how to round a number in Excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I have a formula =concatenate(SelectionTimes!H2," ",SelectionTimes!I2) to show the draft selection of the second round pick. I'd like to know how to make it like the first round where I don't have to manually change the H2 and I2 to H3 and I3 and have it so I can make it work easier.
Solved by A. D. in 19 mins
I want help with round average excel. how do you round your number to the nearest 2 decimal point but after finding an average
Solved by T. Q. in 11 mins
How to round off numbers in excel? I want to round military times to nearest quarter hour.
"START" column
Solved by V. H. in 22 mins
Hi, I am trying to automatically check off a box when two other cells match the same date. When the drop down selection option from the round 1-5 boxes match a date from the schedule box I want the corresponding availability check box to be checked off.
Solved by B. B. in 16 mins
Hi,
I have a little problem doing time sheets. Here is my example: If an employee clocks in before 7:15 I need the time to round to 7:00 am and if they clock in after 7:15 I need the time to round to 7:30. How can I do this ?
So for example if someone clocks in at 6:47 I need the time to round to 7:00 am or if the clock at 7:10 I need the time to round to 7:00 am as well.
Thank you.
Solved by A. F. in 24 mins
in excel round(89.5) = ????
please give me answer to this question
Solved by S. Q. in 25 mins
I am looking for a formula in column Q to round to the value in column L if the value in Q is lower than the value in K. If the value in Q also needs to be a multiple of the value in H. Does this make sense
Solved by G. S. in 29 mins
I need to round values in excel to 2 decimal places
Solved by C. W. in 14 mins
I have an Excel spreadsheet that I've been adding to over a period of time. For some reason it has stopped rounding up my number when they get to point 5 and only rounds up when I get to point 6?
See line 1215 cell K and L. Previously column K would have rounded 13.5 up to 14. See many examples above. For some reason from line 1215 it will only round up at point 6!!
Solved by S. J. in 27 mins
I want to have an embedded pdf but i don't like the icon, so i am wondering if there is a way round this i was thinking of hyperlinking the cells i want to another sheet that has all the pdf's stored and then the vba code to automatically open the correct pdf based on the cell thats been clicked from the original sheet
Solved by M. A. in 24 mins