Excel Rounding up

[Guest]

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?

 

[David Biddulph]

Assuming that you mean $2.50, rather than $1.50, then try either
=ROUND(A2,2)+ROUND(A3,2)
or
Tools/ Options/ Calculation: Precision as displayed.

 

[T. Valko]

Try this:

=FLOOR(A1+A2,0.01)

Format as NUMBER 2 decimal places

Biff

 

[T. Valko]

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

See David's suggestion.

Biff

 

[Guest]

David,

Is this specific to the file or will it effect all files?

Chuck,

If you don't want to effect other formulas on the sheet you can use the
following:

=SUM(ROUND(A2:A3,2))

This is an array formula and must be entered by pressing ctl-sht-enter.
Note: The use of many array formulas can slow down the calculation process.