Hi,
in case anybody should have wondered how to make use of named formulas: bit.ly/namedformula
Cheers
Vince
Hi,
in case anybody should have wondered how to make use of named formulas: bit.ly/namedformula
Cheers
Vince
Vince - I've moved your thread to the appropriate section. You should perhaps re-read forum rule #13b just so that you are aware of our stance on this sort of post. Thanks!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you very much for your assistance! I will definitely re-read the forum rules.
Hi Vince.
I'm little bit of confused about the uses of the named formulas. Actually I'm habituated with the regular functions.
I found the following uses for me:
1. I used to create things like running numbers with "cell above plus one" - which easily broke, when I had to delete rows. With a named formula "Next" I can easily enter the formula in the whole column.
2. I often have tables with complicated lookups - by using a named formula like "VatRate" my worksheets became much more readable - and I also make sure that the same logic is applied to all cells in a column. As a side effect I can also hide the "dirty details" of the lookup from other users.
3. Finally I found good use when I had very complicated calculations, with lots of dependencies. By defining the parts of KPIs and other measures I drastically reduced the probability of errors: when a formula is using a named formula, I am sure that the same value is applied everywhere.
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks