Hello,
I have an inquiry regarding round function and not sure if there is a solution or not
The numbers in Column "A" are depends on some calculations
What I need is to round the numbers in Column "A" to be only as the numbers in Column "D" (looks like (250, 250*2, 250*3, 250*4...))
I used the function in "B1" and changed the numbers and tried so hard to have a result as in "C1" but didn't get what I need
Any suggestions?
<tbody>
</tbody>
I have an inquiry regarding round function and not sure if there is a solution or not
The numbers in Column "A" are depends on some calculations
What I need is to round the numbers in Column "A" to be only as the numbers in Column "D" (looks like (250, 250*2, 250*3, 250*4...))
I used the function in "B1" and changed the numbers and tried so hard to have a result as in "C1" but didn't get what I need
Any suggestions?
A | B | C | D | |
1 | 220 | =ROUND(A1,2-(1+INT(LOG10(ABS(A1))))) | 250 | 250 |
2 | 270 | 500 | ||
3 | 300 | 750 | ||
4 | 400 | 1000 | ||
5 | 515 | 1250 | ||
6 | 780 | 1500 | ||
7 | 1260 | 1750 |
<tbody>
</tbody>