For example, if you borrow $1,000 from a friend and agree to pay 6% simple interest for two years, the formula above tells you that you'll pay $120 in total interest ($1,000 x 0.06 x 2).

You can still subtract, but it’s a simple calculation to begin with: Enter the test calculation =B3-C3 into any cell outside the Table. If it returns the expected results, continue.

This simple calculation will show if you're withholding enough taxes from your paycheck By Kate Dore, CFP®,CNBC ...