View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ranjith Kurian[_2_] Ranjith Kurian[_2_] is offline
external usenet poster
 
Posts: 48
Default 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