Thread: Using the result of formula as part of reference to a cell in form
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default Using the result of formula as part of reference to a cell in form
Try

INDIRECT(C22)/F33

"Victor" wrote:

Hello dears, I need to use the result of a formula as a part of a reference
in another formula.
I have a formula that the result is a direction, ex: $A15 is the result of a
formula in the cell "C22" and I want to use it in another formula, ex:
$A15/F33. So I want to use the result in cell C22 to autoupdate all fromulas
that have that reference.
If I write C22/F33 gives ne an error. I want to use the result of the cell
C22 as the reference.

Any help? I know is not very well explained but...

Thanks to all
Reply With QuoteReply With Quote