Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to get a range of cells rounded off to the nearest value?
i have the following data in cells A2:E2. (14.1,25,26.8,17.9,,48.6) i want to get the figures without the decimals. i tried the following with negative result.
=Round(A2:E2,0) i can get the required result in three steps 1.=Sum(A2:E2,0) gives me the result with one decimal 2.select cell at the top and click on the ribbon to reduce the decimal to nil. 3. use the fill handle is it possible to accomplish the task with one formula? thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show fractions rounded up to nearest 1/16th inch | Excel Discussion (Misc queries) | |||
Average rounded to nearest 0.50 | Excel Discussion (Misc queries) | |||
Allocated amount rounded to nearest .25 without exceeding total | Excel Worksheet Functions | |||
Ensuring input is rounded up to nearest 10 | Excel Discussion (Misc queries) | |||
Calculating parts costs rounded to the nearest $15 in Excell | Excel Programming |