Calculate Payment Schedule [Homework]
While I was away, Hui did a splendid job of starting a new series called Formula Forensics. The idea is to break down formulas for difficult real-world problems so that we can understand them better. In that spirit, I am giving you an interesting and tough formula homework. Situation: Imagine you work for Large Fries […]
10 Excel Formula Myths – Busted!
Many of us start using Excel to keep track of something. And along way, we realize that Excel has a powerful feature called formulas, using which we can automate a lot of things. BOOM! Before we realize, we are in the thick of VLOOKUPs and SUMIFs.
But, along way, we also pick up a few bad habits or believe a few myths. Today, lets bust 10 Excel formula myths that we hear often.
Read this post to learn what these myths and why you should not trust them.
Convert ISERROR formulas to IFERROR formulas [macro]
Last Friday, we have learned about an interesting formula – IFERROR Formula using which you can easily handle errors in Excel workbooks.
Quite a few people reading that page asked, “Wow, this is good. But how can I take a sheet full of =IF(ISERROR(…)….) formulas and convert them to =IFERROR()”
There is a different set of folks who asked “Wow, this is good. But quite a few of my colleagues use Excel 2003 and they see a bunch of #NAME errors when I send them an excel workbook with IFERROR formulas. Any help?!?”
I am pleased to announce that I wrote 2 simple macros, iferror2iserror() and iserror2iferror() that would scan formulas in a bunch of selected cells and convert them from IFERROR to ISERROR and vice-a-versa.
IFERROR Excel Formula – What is it, syntax, examples and howto
If IFERROR() were to be a person, I would hug her so hard that Jo (my wife) would get in to a cat fight with her. I know many a woman (and man) who get in to a fight with Excel formulas often. But thankfully, we avoid that as IFERROR is not a real person. It is, however a darned useful formula.
Since I cannot hug a formula anymore than I can get my son to sit tight, I will go ahead and sing an ode to her, in my style – by writing about how useful and powerful IFERROR formula is.
Excel Animation without Macros!
Today we will learn an interesting animation technique that ONLY uses, … wait for it …, Excel Formulas. That is right, we will use simple formulas to animate values in Excel.
Intrigued? Confused? Interested?
First see a short demo of excel animation achieved using this technique.
Now read the rest of this post to learn more about this technique and download sample workbook.
How to make a Birthday Reminder in Excel ? [Video]
Learn how to create a birthday reminder worksheet in excel in this video post. You can also download a template to keep track of upcoming birthdays and anniversaries.
Excel Links – Happy Birthday Edition
First some personal matters. Today I am celebrating my 28th birthday. The last one year has been very good for us. We have been very busy parenting 2 hilarious and naughty twins, I moved back to India, quit my job and started a company. My business became a mild success crossing $100k revenues in 12 […]