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

I'm having trouble with excel round up to nearest 5. I need to multiple a column then round to the nearest 5 whole dollar while staying in a single column so i need to take the product then round it to the nearest 5

I wanted to convert a value from centimeters to Inches and Feet. in the following format (0' 00'') and I am using the following forumla for this =INT(CONVERT(A1,"cm","ft")) & " '" & 12*(CONVERT(A1,"cm","ft")-INT(CONVERT(A1,"cm","ft"))) & """" The answer is accurate but the only Problem is The value of Inches has a lot of digits after decimal points.. Please help me how to round off in excel the Inches part of the value to two digits after decimal point? Please help me how can I improvise this formula Thanks Saram.

trying to create a timesheet calculator for calculating my hours. I only have 20 hrs a week but they round down the number in increments of .25 or 15 minutes. For Example, if one day I only worked for 6 hours and 10 minutes (which is about 6.22 in decimal) but since I hadn't worked the full 6.25 hours it rounds the hour to 6.00 instead. so I'm wondering how to tell it to round down in increments of 0.25. any ideas?

I'm making a sheet for the Masters tournament competition. Each participant selects 6 golfers from field of ~80. Each participant has a column in table where an "x" corresponds to the six golfers selected. The golfers will play four rounds. I'm trying to make small function that builds an array of scores for the six golfers, and only counts 4 lowest scores for the round for each participant. My =SMALL(IF()) function returns a value error.

I am trying to round a pivot table formula to the thousands. How do I incorporate the =ROUND(below,-3)? Here's the formula =(GETPIVOTDATA("Annual Budget",Bgt_Mattress!$A$3,"Store","1001 - Nitey-Nite Miami")+GETPIVOTDATA("Annual Budget",Bgt_Pillow!$A$3,"Store","1001 - Nitey-Nite Miami")+GETPIVOTDATA("Annual Budget",Bgt_Other!$A$3,"Store","1001 - Nitey-Nite Miami"))*F5

My friend and I want to keep Fortnite stats. What data I would like the function to find is find where each time I typed "prison" in column A5:A50, add together the number in column B5:B50. Basically, I would like to enter the place I land and how many kills I ended up with that round, and then a table that shows each landing site and how many kills I have total when I landed in that site.

I need a formulas using only this functions , Mod IF and or round roundup sqrt min max sin cos to figure out how many hrs does a take to do a job Example. 10 to 20k 30 hrs 20001 to 30 k 60 hrs and so on increments of 10 k increments of 30 hrs

I need help with round in excel. I want to round up but my spreadsheet automatically round to the nearest number.

use the excel sheet name part 2 to answer the question and round the answer to 4 decimal places . Information from the American institute of insurance indicates that mean amount of life insurance per household in the united states is $100,000 with a standard deviation of $40,000 assume the population distribution is normal. A random sample of 100 household is taken What is the probability that sample mean will be more than $120,000? What is the probability that sample mean will be between $100,000 and $120,000?

Information from the American institute of insurance indicates the mean amount of life insurance per household in the United States is $110,000 with a standard deviation of $40,000. Assume the population distribution is normal. A random sample of 100 households is taken. (a) What is the probability that sample mean will be more than $120,00? (b) What is the probability that sample mean will be between $100,000 and $120,000? Round your answer to 4 decimal places. ( use part 2 sheet to answer this question)