To copy the same formula to other cells in Excel is easy, and you can use keyboard shortcuts, AutoFill or Copy and Paste command.

Excel table formulas driving you crazy? Learn the fix to lock column references, prevent errors, and simplify your spreadsheet calculations ...

Here is what the formula would look like in Excel if we hard-coded the values: = (1000 * 3) - ( (1000 * 3) * 0.1) There are a couple of problems here that make this formula complex.