Home |
Search |
Today's Posts |
#1
|
|||
|
|||
test forumla rather than result
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
How can i change this VBA project According to Indian Numeric | Excel Discussion (Misc queries) | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions |