Aug 17 2008

Substitute Formula

The substitute formula is an relatively simple formula that can come in handy in many situations.  I like to use this formula the most when a longer text field needs just a portion of it changed, without having to retype the entire cell value.  Let’s go ahead and take a look at the substitute formula: […]

Oct 1 2007

Calculate a Loan Payment in Excel

Whether you are trying to buy a new house, looking at buying a new car or applying for MORE student loans, you have no doubt wondered what your monthly payment would be. Excel provides an easy to use formula in which you can enter the loan information, and it will calculate the monthly payment for you.  […]

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks