We asked a question of knowledge of Excel, will be the answer, please let ~ ~

In EXCEL, how can a few (rounded), for example, 12,775 rounded to the nearest 12800 ~ ~

choice or out of form used Kin-right, select the unit set up
digital format – value, and then have a choice in the middle of the number of decimal places, you need to choose
to retain the respect of a number of OK on the ceiling with
function if the number in the A1 There
= CEILING (A1, 100), said rounding up 100, can adjust the parameters used in the round function
designated unit Negri enter:= round (12775/100, 2) * 100 = can ROUND (12775, -2), for example A1 = 12775, in the A2 type
= round (A1, -2)
The result is 12,800, and the remaining drag to copy the formula

Leave a Reply