Q
Quahogboy
Hi,
I am new here and did not find the answer to what I need.
I have two sections of data. The first group of rows I need all th
numbers to round DOWN to the nearest thousand (zero if less tha
1000).
example group 1:
3452 to 3000
8993 to 8000
620 to 0
14883 to 14000
5821 to 5000
the second group I need to round all the numbers UP to the NEX
thousand
example group 2:
3452 to 4000
9673 to 10000
780 to 1000
16792 to 17000
1167 to 2000
I have been trying out the round command and can get it to work on th
first group by using
=ROUND(A1, -3)
the only problem is that it gives me 1000 rather than zero for th
value of 620.
The other problem is, how can I get the numbers in example group 2 t
round UP to the next thousand?
If I have not stated this clearly enough please let me know. I a
trying to set up a spreadsheet to automatically calculate something fo
me and it is important that I round these two unique ways. Thanks
I am new here and did not find the answer to what I need.
I have two sections of data. The first group of rows I need all th
numbers to round DOWN to the nearest thousand (zero if less tha
1000).
example group 1:
3452 to 3000
8993 to 8000
620 to 0
14883 to 14000
5821 to 5000
the second group I need to round all the numbers UP to the NEX
thousand
example group 2:
3452 to 4000
9673 to 10000
780 to 1000
16792 to 17000
1167 to 2000
I have been trying out the round command and can get it to work on th
first group by using
=ROUND(A1, -3)
the only problem is that it gives me 1000 rather than zero for th
value of 620.
The other problem is, how can I get the numbers in example group 2 t
round UP to the next thousand?
If I have not stated this clearly enough please let me know. I a
trying to set up a spreadsheet to automatically calculate something fo
me and it is important that I round these two unique ways. Thanks