Rounding dollar amount to nearest $1

[Maddoktor]

Hi all,

I was wondering what the formula is if I wanted to round a dollar amount
to the nearest dollar.

i.e. $150.63 should equal $151.00
i.e. $150.23 should equal $150.00

Thanx in advance.

 

[Ardus Petus]

Say your $ amount is in A1, enter in B1:
=ROUND(A1,0)

HTH

 

[Maddoktor]

Thanx Ardus,

Exactly what I wanted.

Say your $ amount is in A1, enter in B1:
=ROUND(A1,0)

HTH

 

[Don Guillett]

Had you considered looking in the help index for ROUND?