One way:
=ROUND(C3/2,0)
In article ,
boyshanks wrote:
I have a cell which contains the formula: C3/2. When that formula returns a
number such as 9.32, I want it to round DOWN to 9. When that formula returns
a number such as 9.512, I want it to round UP to 10. All in the same cell.
Can you help me with this? I did load the Data Analysis ADD IN but it is
very confusing to me.
|