No that would be internal to the Excel builtin functions and you would
not have access to what Excel is actually doing. You would have to do
your own breakdown.
But I probably misunderstood the question, as I thought you were trying
to equate the formulas as the same but 2) did not include A2 and
formula 4) used a multiply instead of an addition so ...
If you are simply trying to obtain the formula used in a cell see
http://www.mvps.org/dmcritchie/excel/formula.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"prasanta" wrote in message oups.com...
Hello,
I have a problem with the Excel Cell formula. I want to extract the
what are the referance cell for a particular formula.
Like if I use :
<range.Formula
Its return something like(depend on formula)
1) =SUM(A1:A3),
2)=A1+A3,
3)=A1+A2+A3,
4)=A1*SUM(A2:A3).
So, is there any built in function or types in C#.NET through which i
can eassily get the referance cell.
Please Reply me.
Thanks,
Prasanta