shehla_sohail
Sep 12, 2012, 11:48 PM
I would like the numbers rounded to the nearest 0.5.
For example:
1.43 ---> 1.50
0.26 ---> 0.50
0.14 ---> 0.00
Data is :
0.24%
0.36%
-2.97%
0.18%
-2.56%
-2.15%
0.06%
-3.64%
-0.07%
1.22%
-5.53%
4.23%
-1.49%
-0.27%
0.98%
1.12%
4.24%
-3.62%
-2.65%
-0.16%
1.37%
-0.23%
1.42%
3.57%
-0.33%
-4.85%
0.61%
0.52%
-2.02%
-4.65%
-0.86%
-0.01%
-1.41%
-3.54%
I am looking for excel formula to save time as there is so much data.
For example:
1.43 ---> 1.50
0.26 ---> 0.50
0.14 ---> 0.00
Data is :
0.24%
0.36%
-2.97%
0.18%
-2.56%
-2.15%
0.06%
-3.64%
-0.07%
1.22%
-5.53%
4.23%
-1.49%
-0.27%
0.98%
1.12%
4.24%
-3.62%
-2.65%
-0.16%
1.37%
-0.23%
1.42%
3.57%
-0.33%
-4.85%
0.61%
0.52%
-2.02%
-4.65%
-0.86%
-0.01%
-1.41%
-3.54%
I am looking for excel formula to save time as there is so much data.