S
sumesh56
i have the following data in cells A2:E2. (14.1,25,26.8,17.9,,48.6)
want to get the figures without the decimals. i tried the following wit
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 decima
to nil.
3. use the fill handle
is it possible to accomplish the task with one formula? thank
want to get the figures without the decimals. i tried the following wit
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 decima
to nil.
3. use the fill handle
is it possible to accomplish the task with one formula? thank