• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

2. Hacking Excel for Financial Analysis > Add Conditional Commentary

Add Conditional Commentary

You can use the Excel IF function to display reminders or recommend appropriate steps to take based on the values for a company’s financial results.

When you learn something new, some points don’t sink in the first time, particularly when the topic is as broad as investing. For a while, you must refresh your memory each time you look at a financial measure—“Why should I care about this?” or “Is this number good or bad?” Suppose you build a fancy spreadsheet for evaluating investments. Then, after a well-deserved vacation, you come back with no clue as to why you calculated the inverse sales to popularity ratio—at least you think that’s what you were supposed to calculate—nor do you remember how to use your masterpiece of a worksheet. Just like comments in code, instructions and notes in your worksheets aren’t a symptom of a compulsive disorder. They are a valuable aid to you, the author, helping you to remember wha....


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint