excel

[Bridget]

How do you round up numbers in a column. Example:
$2785.55. I would want to round it up to 2786.00. Also
how do you round down. Example $2785.33. I would want
to round it down to $2785.00. Thanks.

 

[Alfred]

Syntax from Excel Help

ROUNDUP(number,num_digits)
ROUNDDOWN(number,num_digits)

 

[Sandy Mann]

Bridget,

If you mean round up if the decimal part is0.5 or more and round down if
less the use the ROUND function to zero decimalplaces:

=ROUND(<cell>,0)


HTH

Sandy