Posted to microsoft.public.excel.worksheet.functions

Ranjith Kurian[_2_] Ranjith Kurian[_2_] is offline

external usenet poster

Posts: 48

fomula to divide

in cell A1 i hv typed the amounts as follows CellA1=37020+400+2676.8+247009.68
and in cell A2 the rates typed are as follows =7.7519+1+49.3945+1
now i need my CellA2 rates to be divide with CellA1 amounts as per arranged
example

RESULT
37020/7.7519 + 400/1 + 2676.8/49.3945 + 247009.68/1
and the expected result is252239.4757

Is there any formula to dividethe CellA1/CellA2 as per the arranged orders,
with out any manually work

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
If fomula	Joe Perez	Excel Worksheet Functions	6	April 28th 09 02:27 AM
Help in a fomula	Malik Nadeem	Excel Discussion (Misc queries)	0	January 10th 09 11:09 AM
Fomula (if?)	Jules	Excel Worksheet Functions	0	August 8th 06 07:13 PM
IF Fomula	DWadding	Excel Discussion (Misc queries)	1	August 3rd 05 05:32 PM
Divide one row over other row I dont wont to divide one number	Rick	Excel Discussion (Misc queries)	0	March 4th 05 07:13 PM

All times are GMT +1. The time now is 08:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us