| A | B
------|-----|--------
1 | x | 1
2 | y | 2
3 | z | 3
4 | a | =B1*B2+B3
imagine the above stuff is part of an excel sheet, and B4 has a formula =B1*B2+B3
.
Is it possible to extract the real formula from excel formula? i.e. in the above example, the real formula is a=x*y+z
the reason why i want to do the "transformation" is that I have many excel sheets filled with data and formulas, and now I want to quit Excel and use javascript for calculation, so I want to have the real formulas .
z=x+y
is the same asa=b+c
etc. So likez=x+y
ISz=B1+B2
. The excel formula IS the real formula. - slebetman=x*y+z
- Scott CranerF2
or simply look in the editor window at the top of Excel. If you are using this formula in multiple places though, you may be better off using a name. - rhughes