Numbers Calculate the difference between two numbers by inputting a formula in a new, blank cell. If A1 and B1 are both numeric values, you can use the "=A1-B1" formula.

In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find.

How to Use an Alphanumeric Mix in VLOOKUP Statements in Excel. Excel's VLOOKUP function searches cell arrays for data that you provide.

1. Make A Budget Once you enter your financial information into a blank spreadsheet, you can tell Excel to perform calculations and analysis using formulas.

How to subtract in Excel using cell references You don't have to subtract numbers in a single cell; you can also set up a formula that will subtract the values stored in multiple cells.