# 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!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

Basically for each entry in the "Packet Games" section we can have multiple winners and they can be both Single and Double winners. One single winner would win 40.00 as long as they are the only winner, and the payout needs to round up to the nearest .25 If n15>0 then calculate using O13 to complete Roundup(O13/C5/0.25,0)*0.25. The excel roundup function is not working
Solved by S. U. in 14 mins
How to round up in excel, my total needs to round up to the nearest .25, needs to look at another cell and if there is an entry split the total.
Solved by O. J. in 11 mins
I'm trying to build a spreadsheet to keep tracking of scoring/player for each round of an outing. I need help syncing players names to tables so it auto updates based on their name, I also need help with an if analysis to show 0 if the cells are blank. I hope that makes sense, it's kind of complicated. Thanks!
Solved by F. S. in 16 mins
I have a spreadsheet created. However, I need the formula to work off of text too, not just a number. This is my formula: =IF(AND(K5>0,L5>0,M5>0),ROUND(VLOOKUP(TEXT(K5,"00.000")&TEXT(L5,"0.000"),'Shape, Support Tooling'!A2:G19,5+M5,FALSE),0),"") Where M5 is, is where I would need the column to have words in it instead of going off numbers
Solved by E. U. in 12 mins
I need to round =(I3-H3)/H3 down to 2 decimal places but I'm can't figure out how to round decimals.
Solved by V. D. in 15 mins
Hi! I created a table I think I did ok so far but I'm stuck when the punch in is on one date and the punch out date is another date. So please hopefully you can help me, it would greatly be appreciated! I don't need to add lunch breaks but I do have to round up on punch in and round down for punch outs to nearest 15 minutes. Punch in time is rounded up to the nearest 15 minutes 8:01 - 8:14 = 8:15 8:16 - 8:29 = 8:30 8:31 - 8:44 = 8:45 8:46 - 8:59 = 9:00 I used this formula : =CEILING(F23,"0:15") Punch out time is rounded down nearest 15 minutes 8:01 - 8:14 = 8:00 8:16 - 8:29 = 8:15 8:31 - 8:44 = 8:30 8:46 - 8:59 = 8:45 I used this formula: =FLOOR(H23+"0:01","0:15") Then I have the cell that formulates the hours clocked I used this formula: =TEXT(I23-G23,"H:MM") The final cell then formulates the total hours I used this formula: =(J23-INT(J23))*24 As I mentioned above, the issue I'm having is punch in on one date and punch out on the following date. I tried pasting example here but it didn't show. Thank you in advance :)
Solved by V. B. in 21 mins
hi, i need to make formula so if i say in cell a2 =yes i want be to b2 to say £150.00 i have tried if function but need to do it wrong way round and can not get my head around it
Solved by C. E. in 14 mins