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

I need to compute the total cost and the percentage of each item. formatting it as a decimal to 3 places and a percentage into 1 place

Solved by F. C. in 28 mins

I have a formula that sums a column and adds a space then a text value derived from another sheet. The result is giving me the whole value then a decimal and 9 zeroes. When I remove the code to add the text value the formula returns a correct single decimal place value.

Solved by M. A. 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

In cell J3, use a VLOOKUP function to determine the discount earned based on the cost of trip and the data on the Agency Data and Analysis worksheet. Format as Percentage with 1 decimal place.

Solved by B. B. in 25 mins

the number of short term parking spaces at 10 airports is shown. Round your answers to one decimal place
3766 3151 6756 1126 3716 4089 3113 3167 8135 3812
find the mean,median,midrange, and the mode of short term parking spaces at 10 airports.

Solved by V. H. in 21 mins