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

I need to round values in excel to 2 decimal places

Solved by C. W. in 14 mins

I need a formula that rounds up and moves the decimal point 2 places to the right. I'm multiplying the first number by the second number that gives me 4954.73. Then in the last row I want to round it up and move the decimal place 2 places to the right.
729.71
6.7900
4954.7309
49.55

Solved by V. E. in 25 mins

Create the following items in the Values-area, which will be used to answer Q1-Q4. o Number of transactions (using the COUNT function). Format the column with a “,000” separator and do not include any decimal places. Average of quantity purchased per transaction. Format the column with a “,000” separator and show two (2) decimal places). Average of unit price. Format the column with a currency format, e.g., 1234 should show as $1,234.00, and showing two (2) decimal places. Total dollar value of transactions for the sector. Format the column with a currency format, e.g., 1234 should show as $1,234.00, and showing two (2) decimal places.

Solved by V. A. in 29 mins

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.

Solved by T. Y. in 29 mins

Use these data to construct a 98% confidence interval to estimate the average per diem expense for business people traveling to Johannesburg. Assume per diem rates for any locale are approximately normally distributed. Round your answer to 2 decimal places.

Solved by V. S. in 26 mins