View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Akhare Akhare is offline
external usenet poster
 
Posts: 1
Default Formula as text in cell

Hello

Is it possible to do a lookup on a table containing formulae and apply the
derived formula.

The table of formulae may contain for example the following values

A sum(a1:a2)
B sum(b1:b2)
C sum(c1:c2)

I cannot use nested IF statements as the actual formulae used by me are long
and extend over 1024 charaters.

Could anyone please provide me some way to achieve this?

Thanks