Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Does cell contain formula without using UDF
Without using a UDF is there a function you can use to return true if a
formula is in a cell?? Thanks, |
#2
|
|||
|
|||
XLM:
1. Press Ctrl+F3 and define a name "isformula" (no quotes) as: =LEFT(GET.FORMULA(INDIRECT("RC[-1]",FALSE)))="=" 2. Now call it in a cell like this: =isformula Some notes: 1. It will evaulate the cell to the immediate left. 2. It will return TRUE in cases like =7 where an equal sign is not necessary. 3. There is some risk involved with using this method. Please read: http://tinyurl.com/3jsqt HTH Jason Atlanta, GA -----Original Message----- Without using a UDF is there a function you can use to return true if a formula is in a cell?? Thanks, . |
#3
|
|||
|
|||
Jason Morin wrote...
XLM: 1. Press Ctrl+F3 and define a name "isformula" (no quotes) as: =LEFT(GET.FORMULA(INDIRECT("RC[-1]",FALSE)))="=" .... In what conceivable alternative universe would this be preferable to =GET.CELL(48,INDIRECT("RC[-2]",0)) ?! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
looking for a formula | Excel Worksheet Functions | |||
How can I write an if-then formula for 0 or less than 0 in cell t. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |