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.