How do I format cells to round up?
I did that but it keeps giving me the circular reference error. The values
that appear in the cell are being entered as the result of a formula.
"CorporateQAinTX" wrote:
Have you tried using the =ROUNDUP() function? You're supposed to put the
number and then the number of decimal places in the parenthesis, but you can
list a cell value for number like A1 instead. If you want a whole integer
just put a 0 like this:
=ROUNDUP(A1,0)
This will take whatever number is in A1 and round it up every time.
QA Techie
"Tom" wrote:
I want to format a cell or column in a worksheet to always round up the value
to the nearest integer. My skills here are limited so please reply in
"layman's" terms.
|