Create a Custom Excel Function to Replace Nested IF Functions
Do you get frustrated writing formulas that require that IF Functions and AND Functions be nested inside each other? Most people do get frustrated - especially when they need to make changes to the formula.
Let me show a faster and easier way to solve this problem - I will demonstrate in just over 7 minutes how to create your own custom functions in Excel - to accomodate as many layers of IF statements as you will ever need!
I use the example of writing a formula to grant a different discount per sales order depending upon how many units are ordered. This is a common situation - and it becomes compounded when the sales manager decides to revise the discount tiers!
If you thought that using VBA (Visual Basic) fwas difficult, think again. You can construct this custom function in less than ten minutes, even if you have never recorded a Macro. It is that simple to create!
I invite you to visit my online shopping website - http://shop.thecompanyrocks.com - to view all of my videos and to sample the many resources that I offer.
Danny Rocks
The Company Rocks
Смотрите видео Create a Custom Excel Function to Replace Nested IF Functions онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Danny Rocks 25 Июнь 2011, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 29,880 раз и оно понравилось 138 людям.