Excel Rounding up
 

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?

Excel Rounding up
 

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.
--
David Biddulph

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

Excel Rounding up
 

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?

Excel Rounding up
 

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?

Excel Rounding up
 

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.

"David Biddulph" wrote:

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.
--
David Biddulph

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