Possible To Define A Generic Function In One Cell And Call This Function From Other Cells?

I have a question about whether or not you can define a generic function in one cell, then "call" this function from various other cells. Something like a function template which is a common feature in many software programming languages.

Let's say I have an Excel spreadsheet for entering and calculating information about several different images, Width, Height, and Aspect Ratio. The Width and Height properties are entered manually, but the Aspect Ratio is calculated (Width/Height).

The cells containing the Aspect Ratio for each image are not in any contiguous row or column due to the way I have laid out my cells.

Here is a picture of what my image worksheet looks like:

Images_Sheet.png

http://i144.photobucket.com/albums/r...psbed1d4e2.png

For each Aspect Ratio cell I could just enter the following formula(s):

C5: = C3/C4
C10: = C8/C9
C15: = C13/C14

But let's say I wan't to get fancy and define a formula for calculating the Aspect Ratio in another cell and then have each of the cells reference the formula indirectly. So, in another worksheet I create a formula table an in one of the rows I enter the following (I know the syntax is incorrect, I am just trying to demonstrate what I am after):

D4: = w1/h1

Where w1 and h1 don't reference an actual cell, they are more like parameters to the function.

Here is a screenshot of my function worksheet:

Formula_Sheet.png

http://i144.photobucket.com/albums/r...ps4f802484.png

Obviously this does not work as it is but I was wondering is there a way to do what I am trying to do? To define a generic function in one cell and call that function from other cells?

Thank you,

Jan

P.S. I have attached my example spreadsheet to this post.

unsure why anyone would do it this way but it is ...plausible

you could possibly use formula like

Formula:

Please Login or Register  to view this content.

use name range = width1 and height1

ps you cant use w1 or h1 as they pre-exist as actual cells references

i can also think of some offset/match/index combination that could work without technically knowing the exact cell reference but some relative cell reference to "IMAGE 1" for instance

see attached example of what i mean for both solutions

C5 using named range and column G for the combination formula