Set a range of cells for ROUNDUP
Use the Int function or roundup, rounddown functions for a single cell. Not
sure what you are doing with a range of cells, summing them?
Your range of B88:B88 is only a single cell. eg =Int(B88)
"Richard" wrote:
I don't use Excel very often, so this is probably a dumb question, but...
I want to set a range of cells (B88:B88, to be exact) so that the calculated
value is rounded up to the next integer.
Can someone explain how to do that--if, indeed I can.
Thanks
|