View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default 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.