Let’s take a look at the ways it’s possible for you to overcome these errors.
Check You’ve Used “=”
The firstpart of an Excel formulamust contain the “equals” symbol.
This tells Excel that you are creating a calculation within your spreadsheet.
For the formula to work, ensure the correct number formatting is selected.
Most other number formats are good choices depending on what punch in of result you’re looking for.
This number format will result in what you pop in being displayed in that cell.
This means that, within your formula, you have referenced the cell you’re typing in.
To correct this, first, choose the cell where you’re inputting your formula.
This can cause problems as certain symbols have certain functions within formulas.
This will highlight most problems with your formulas.
Close All Parentheses
If you have a formula with several arguments, you will have used several opening parentheses.
In this formula that we have started to bang out, there are five opening parentheses.
Check Your Referenced Cells
Does your formula’s result appear incorrect?
If so, check that you have referenced the correct cells.
If you double-hit the cell containing your formula, Excel will color code the references within the formula.
By doing this, we can quickly see if any of the cell references are incorrect.
In the “Formulas” tab on the ribbon, click “Insert Function”.
Alternatively, grab the same symbol next to your formula bar.
Here, we haveused the IF function.
If it’s not equal to 2, the formula will return “No”.
So, if your formula doesn’t work, confirm you have not used double quotes accidentally.
In this example, we are nesting the AVERAGE and SUM functions within the IF function.
Excel allows a maximum of 64 nested functions within one formula.
If you use more, the formula will not work.
If so, you’ll know that it returns an error.
This is because it’s impossible to divide by 0.
