I've get a spreadsheet that averages numbers from three sources. It works fine, but the answer other have lots of decimal places (example: 8.1666666...).
Here's an example of what the formula looks approaching immediately:
=Average(B2:D2)
How do I obtain that to round past its sell-by date to the nearest tenths?
Answers: I assume you are using EXCEL. This is what you do.
1. Highlight the Cell that have the number.
2. Go to the top of the Screen and you should see a Command call "FORMAT". Click on it.
3. You will see sundry information bank of what type of merit you want surrounded by that cell. I assume it is a number. Click on "Number".
4. This will dispense you a exotic blind that allows you to control how heaps Decimal Places you will see on your spread Sheet for that cell. Since you want Tenths, put the number 1 in the box. The system will non-attendance to "2".
If you want percentage, select "Percentages" instead of "Number" and do like for the decimal places.
Hope this help.
Try this...
=Round(Average(B2:D2),1)
Bert
Bert C's answer is correct: =Round(Average(b2:d2),1).
Using: =Round(Average(b2:d2),2) will round to the nearest HUNDRETH.
Using the format picking does not round the number, it single change what you see, so that if you put in the numbers you will still take "rounding" errors.