Adding Numbers

D

Denise

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

Myrna Larson

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

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

Ron Rosenfeld

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.
Click to expand...


--ron
 
R

Ron Rosenfeld

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.
Click to expand...

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
 
Top