Adding Numbers
 

I need to set up a formula to add numbers to get the following sum:

12.50 + 12.40 = 25.30

Not: 12.50 + 12.40 = 24.90

..60 should equal 1. Is there a way that this can be done.

Thanks.

Use the DOLLARFR and DOLLARDE functions from the Analysis Tool Pack:

=DOLLARFR(DOLLARDE(12.5,60)+DOLLARDE(12.4,60),60)


On Mon, 10 Jan 2005 12:03:02 -0800, Denise
wrote:

I need to set up a formula to add numbers to get the following sum:

12.50 + 12.40 = 25.30

Not: 12.50 + 12.40 = 24.90

.60 should equal 1. Is there a way that this can be done.

Thanks.

On Mon, 10 Jan 2005 12:03:02 -0800, Denise
wrote:

I need to set up a formula to add numbers to get the following sum:

12.50 + 12.40 = 25.30

Not: 12.50 + 12.40 = 24.90

.60 should equal 1. Is there a way that this can be done.

Thanks.


--ron

On Mon, 10 Jan 2005 12:03:02 -0800, Denise
wrote:

I need to set up a formula to add numbers to get the following sum:

12.50 + 12.40 = 25.30

Not: 12.50 + 12.40 = 24.90

.60 should equal 1. Is there a way that this can be done.

Thanks.

You need to convert the numbers somehow. There are a variety of methods:

====================================
=dollarfr(dollarde(12.5,60)+dollarde(12.4,60),60)

Format the result as Number with 2 decimal places.
You can replace the numbers 12.5 and 12.4 with cell references.

If these functions are not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.

==============================

Or, without the ATP, and with the values stored in H1 and H2, you could use the
following array formula:

=INT(SUM(INT(H1:H2),MOD(H1:H2,1)/60*100))+
MOD(SUM(INT(H1:H2),MOD(H1:H2,1)/60*100),1)*60/100

To enter an array formula, hold down <ctrl<shift while hitting <enter.

===============================

You could convert the numbers to times and format the result as [h].mm



--ron