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 |
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 |
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 |
All times are GMT +1. The time now is 12:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com