Adding Numbers - ExcelBanter

Myrna Larson

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Seed numbers for random number generation, uniform distribution	darebo	Excel Discussion (Misc queries)	3	April 21st 23 09:02 PM
Excel Adding duplicated numbers together	JJ Joobler	Excel Discussion (Misc queries)	1	January 7th 05 01:24 AM
Re What is the formula for adding multiple numbers in a cell	merlin_au	Excel Discussion (Misc queries)	2	January 4th 05 11:50 AM
What is the formula for adding mulitple numbers in one excel cell.	Merlin_au	Excel Discussion (Misc queries)	1	January 4th 05 10:50 AM
adding only positive numbers	Jacob	Excel Discussion (Misc queries)	2	November 30th 04 12:24 AM

All times are GMT +1. The time now is 12:42 PM.

Menu

About Us