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!
Bookmarks