+ Reply to Thread
Results 1 to 1 of 1

How to use relative reference with a Function?

  1. #1
    Registered User
    Join Date
    07-18-2011
    Location
    Venice, FL
    MS-Off Ver
    Excel 2007
    Posts
    8

    Smile How to use relative reference with a Function?

    Hello all,

    I have attached a worksheet for simplicity since I don't really know the proper terminology to explain what I'm attempting.

    Rather than using a complex, nested, IF function, I am trying to use a table of multiple, simpler functions. I need to learn how to make those remote functions *know* how to use the relative address the request came from.

    For example, (B8) has a formula that determines it needs to use the function in LINE THREE of my 'table of functions' for a calculation. (C8) and (B7) have numbers in them that are necessary for use in that calculation.

    The question is: how do I code the functions in my 'table of functions' to know to use (C8)&(B7)? (B15) may also need to use the function in LINE THREE, so when directed to use the LINE THREE function, it must *know* to use the data in (C15)&B(14).

    Thanks!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1