How do I use a "master" function?

Question

Hi there

I am creating a big Excel sheet with several tables. I have some functions which I use in multiple field over and over again. Can I somehow define a "master" function, or save that function into a variable so I can use the "master" function in multiple fields?

The function should be executed in the result field.

My goal is that I can edit this master function and then this function gets "deployed" or refreshed in the whole sheet.

Any idea if this is possible and how to do it? Without VBA would be great.

Thanks a lot

Janis Wolf

***Post moved by the moderator to the appropriate forum category.***

Answer 1

Yes it it possible in 2 ways:

(1) Using Visual Basic for Applications (Excel VBA)

(2) Using IF function in your whole cells that will give you the result

Answer 2

Thanks for the answers.

I solved the problem with a custom vba macro.

Answer 3

You can explore Name Manager for this functionality if VBA is not preferred. Through Names, you can create formulas also...

https://support.office.com/en-us/article/Define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64

Well, I want to save a formula into a name (variable). Then I could use this defined name (variable) in my excel sheet. I don't need to use a name in a formula.

I could not find out, how to do this...

Answer 4

Hi there

Thanks for answering!

Well, If possible, I want to avoid VBA, so the second solution sounds pretty interesting to me.

How does the second solution work?

Simplified, here is what I want to do:

I want a to add the values from the 2 cells above, and print the result in the cell below (where the function is executed). From those function cells I've got many more, and a master function would be helpful. If, for example, I need to add 3 cells above (instead of 2), I could just edit the master function.

Friendly regards

Janis

Answer 5

You can explore Name Manager for this functionality if VBA is not preferred. Through Names, you can create formulas also...

https://support.office.com/en-us/article/Define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64