Creating a function to simplify a more complex function

Greetings. I am a mid-level sort of Excel user, but I don't often create my own functions. I'm familiar with VBA for Access, but not for Excel.

Anyway, I don't know if this is possible, but I have a formula that I'd like to make into its own function. I've tried looking up how to do this, but I can't find anything.

The formula:

Please Login or Register  to view this content.

What I'm trying to do is make it so that rather than copying the cell again and again to where I need the formula, I can just create a new function, called FldPos, that will allow me to type "FldPos()" into a cell and have it behave as though this formula is in the cell (excelpt with relative cell references rather than specific ones

Is that possible? If so, how can it be done?

Thanks for any help anyone can give!

Which cell would originally have contained that formula?

If cell N1751 would contain your formula...try this

• I believe this will work just like your formula:
N1751: =IF((A1751<>"")*(B1751<>""),IF(A1750<>"",N1750,A1748),0)

• Select cell 1751
• Insert.Name.Define
...Names in workbook: FldPos
...Refers to: =IF((A1751<>"")*(B1751<>""),IF(A1750<>"",N1750,A1748),0)
...Click: OK

Now you have a "named formula":
• replace the formula in N1751 with this:
N1751: =FldPos

You should see the same results.

Now...you can select any cell in Col_N and use the formula: =FldPos
and it will be like you copied the original formula into that cell.

Is that something you can work with?