kumar1962
04-22-2010, 11:52 AM
I have a simple spread sheet with one cell contains formula.
1st column is Qty, second column is rate and third column is the cost which is the multiple of previous colums.
I am looking a way to show the 3rd column rounded to 0.5.
I can do it by using Mround function in 4th column but I want to display the 3rd column rounded to 0.5 without loosing the formula.
Appreciate any idea.
Regards
Kumar
Current Display
Qty--------rate--------Cost(Qty*rate)
-3---------0.372------36.868
Want to display like this
Qty--------rate--------Cost (Qty*rate)
-3---------0.372------36.500
1st column is Qty, second column is rate and third column is the cost which is the multiple of previous colums.
I am looking a way to show the 3rd column rounded to 0.5.
I can do it by using Mround function in 4th column but I want to display the 3rd column rounded to 0.5 without loosing the formula.
Appreciate any idea.
Regards
Kumar
Current Display
Qty--------rate--------Cost(Qty*rate)
-3---------0.372------36.868
Want to display like this
Qty--------rate--------Cost (Qty*rate)
-3---------0.372------36.500