Get instant live Excel expert help to learn how to round a number in Excel

I'm working with football match data and I need to ensure that there is no duplicate teams in every round (as a team can only play once per round)

The idea is to find the best possible team that could have been assembled to while staying under a certain rating cap. Each player gets 4080 rating points (for example) to create a four-man team. After all the scores are in for the tournament, I hope to have a way to be able to go through the data and show what was the best team a person could have assembled under the specified rating to achieve the best (lowest) score possible. Ideally this section wouldn't populate until the overall scores were finalized in the spreadsheet. I have a way of keeping "NS" if the round hasn't started and "F" if the round finished.

Determine the Handling surcharge for items which are fragile and insurance cost for items which have a high value. (Handling surcharge for fragile items + Insurance for high value items) Write an Excel formula in cell packlist!G3 to calculate this value for the corresponding item. Handling surcharge and Insurance values are given on sheet handling. Round these charges to the nearest cent. Copy your formula down the column to determine this value for each corresponding item

every time I type a formula that uses a function like "round" or "concantenate" I get an error "There's a problem with this formula. Not trying to type a formula?" etc. etc. This is a recent development and is causing issues with my work. I've checked the settings and the separators are set as they should be. Any ideas?

Im trying to work out a formula that say I have 62m of copper pipe I want to work out a formula that divides 62m by 1.2 which is what pipe insulation comes in. 62/1.2= 51.6 so you round it up to 52 lengths

I'm looking for a way to round up integers by multiples of 6. Ect 6 would be 6 7 Would be 6 . . . 11 Would be 12 12 Would be 12

1. Find models 1980(x), 2012(x), and 2017(X) with output Sea Ice Extent and input month for the 1980, 2012, and 2017. Use 10 decimal places when doing calculations but round answers appropriately.

Based on the Total development area given in the Units worksheet, write an Excel formula in cell Units!D9 to calculate the number of Lake plots you will build per the allocation described in the Units worksheet. This formula should also work when you copy it down to determine the number of Center plots you will have and finally, the number of Road plots. (Use the ROUND function to round the number down to the nearest whole number.)

I need to have 3 separate outcomes in a column but excel wont allow it. This is what I have typed in =(IF(H20="","",IF(H20=<0.10%,"<0.10%",IFERROR(ROUND(H20,1),""))))

I have a number in a excel formula round up that I need to round up to the next 100. For example I have a number of 2499 sq. ft that I need to calculate at a rate of $3 for every 100 feet over the first 1000 sq. ft. - that number is 1499 but I need to round up to 1500. =B60-1000 sorry if I don't make sense...