Hi,
Something you might want to try....
Use a find and replace to change the first part of the formulas from "=" to
" =." (Put a space in front.)
The formulas then become text and you can test them.
You can always find and replace to change them back.
Just a thought.
--
Ken Hudson


"Ruthki" wrote:


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