Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use GETFORMULA() in EXCEL 2003?
I am not so sure about this ? Can someone explain to me how to setup
GETFORMULA() in EXCEL 2003 ? -- "Bright minds are blessed to those who share them.."-rsb. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use GETFORMULA() in EXCEL 2003?
I am assuming you mean GET.FORMULA()
Assume a cell named Profit contains this formula: =($A$6*$C$4)+$B$8 Define an arbitrary name PF_text Insert Name Define PF_text Refers To: =GET.FORMULA(Profit) When you enter this into a cell: =PF_text you will get this text =(R6C1*R4C3)+R8C2 Probably not what you want since it is in R1C1 style. To get a result in A1 reference style, use this instead: Insert Name Define PC_text Refers To: =GET.CELL(6,Profit) =PC_text will get you this text: =($A$6*$C$4)+$B$8 If you use names instead of cell references in Profit, either function will give you the same results. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use GETFORMULA() in EXCEL 2003?
It's possible to pass references to these functions in a worksheet
formula using the following technique. With A1 selected define the name Ref as: Ref: =TEXTREF("if("&MID(GET.FORMULA(!A1),6,250)) Then use the syntax =IF(1,Function,Reference) in a formula. So to find the formula in A1 define the name get.formula as below and enter in any cell: =IF(1,get.formula,A1) get.formula: =GET.CELL(6,Ref) This also recalculates whenever A1 changes. Herbert Seidenberg wrote: I am assuming you mean GET.FORMULA() Assume a cell named Profit contains this formula: =($A$6*$C$4)+$B$8 Define an arbitrary name PF_text Insert Name Define PF_text Refers To: =GET.FORMULA(Profit) When you enter this into a cell: =PF_text you will get this text =(R6C1*R4C3)+R8C2 Probably not what you want since it is in R1C1 style. To get a result in A1 reference style, use this instead: Insert Name Define PC_text Refers To: =GET.CELL(6,Profit) =PC_text will get you this text: =($A$6*$C$4)+$B$8 If you use names instead of cell references in Profit, either function will give you the same results. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |