Get instant live expert help on round function 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
in excel round(89.5) = ????
please give me answer to this question
Solved by S. Q. in 25 mins
In cell C2, edit the function to round the result to the nearest penny.
In cell C1, use the MODE.SNGL function to determine the most frequent length of stay using whole days.
Solved by C. E. in 12 mins
I need a hand with a nested if formula =IF($C$6="Round 1",'Round 1'!M7,IF($C$6="Round 2",IF($C$6="Round 3",IF($C$6="Round 4","")))) it works for round 1 but when i select round 2>4 it wont. i need to duplicate but not sure how to. Your help is appreciated.
Solved by Z. Y. in 14 mins
How to do excel round to nearest 1000 with a formula in excel
Solved by S. Q. in 28 mins
The formula below is coming back with an error; "You've entered too few arguments for this function" I dont know why? Can anyone help?
=concatenate(round(($B$1/D5)*C5), " Grams or ",round((($B$1/D5)*C5)*0.0352,2)," ounces of ", A5, " weighed on a food scale")
Solved by M. H. in 27 mins