Get instant live Excel expert help to learn how to round up 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
Trying to solve a formula for time of service between 2 dates. I would like to be able to rounddown if not at least half of the month would be expelled and roundup if more than half the month would be expelled
Solved by Z. Y. in 20 mins
I have the following formula: =AVERAGE(C8:GY8)-35, but I want to add that when a cell shows a negative number, i.e. -2, that the cell should show 0. This is a generic golf handicap formula, and I want the lowest handicap a person can have to be zero. I've tried numerous functions; ROUND, ROUNDUP, IF, but cannot get the formula to work. What can I add to my formula to get the desired result?
Solved by O. E. in 19 mins