“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

Solved by B. B. in 28 mins

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.

Solved by C. F. in 23 mins

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?

Solved by C. C. in 14 mins

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.

Solved by Z. Y. in 11 mins

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

Solved by C. U. in 21 mins

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.

Solved by A. U. in 23 mins

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

Solved by D. H. in 30 mins

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

Solved by T. W. in 26 mins

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?

Solved by B. Y. in 21 mins

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)

Solved by F. Y. in 19 mins