We use an Excel spreadsheet to calculate drug doses for our veterinary
surgical practice. Is there a way to format the cell to round up or down? I
have tried using the round function but it does not work the way we need it
to. Basically, if the number after the decimal point is greater than or
equal to 5, we want it round up (or down, if need be). The only reason it
matters is because we base other calculations on the worksheet on this
calculation and it throws the rest of them off.