Excel Rounding up

C

Chuck

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?
 
D

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

T. Valko

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

See David's suggestion.

Biff
 
E

Erin Searfoss

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.
 
Top