I think I misunderstood what you want. My suggestion rounds down to the
nearest 0.01.

See David's suggestion.

Biff

"T. Valko" wrote in message
...
Try this:

=FLOOR(A1+A2,0.01)

Format as NUMBER 2 decimal places

Biff

"Chuck" wrote in message
...
I have two values in two seperate cells:

$1.254
$1.254

I have them both set to show 2 decimals so it reads:

$1.25
$1.25

So when I add them together with a third cell set at 2 decimal places it
reads:

$2.51 - because it is adding $1.254 + $1.254 = $2.508 and it is rounding
up.

Can I get this to read: $1.50?