Hi Ruthki,
You could create a named formula using XLM function GET.CELL() as follows:
1) select the cell [B1] on your sheet
2) go to menu InsertNameDefine...
3) in the 'Names in workbook' box of the dialog write: Formula
4) in the 'Refers to:' box write: =GET.CELL(6,!A1)
5) press 'Add' button and then 'OK'
Now find the cell whose formula you want to evaluate and introduce the
following formula in the cell immediately to the right:
=Formula
Note: although I personally have never experienced any problems with XLM
functions, some people report that they may occasionally cause Excel crash
loosing all unsaved data.
Regards,
KL
"Ruthki" wrote in
message ...
I would like to write a forumla that looks at the formula in a cell
(rather than the value the cell returns. - how do test the forumla
rather than the result.
example
one cell might have a forumula starting off
=right(a1,5)
another cell might have
= mid(a4,2,3)
I would like to write another if formula that does something if the
cell contains the word right in the formula and something else if it
contains mid.
--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile:
http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=385042