When you see the #VALUE error, it means that there is something wrong with the way the formula is typed, or there is something wrong with the cells you are referencing.

How to subtract numbers in a single cell in Excel Standard subtraction in Excel is relatively simple. Click in an empty cell, type an equal sign and then enter the numbers you want to subtract.

Here's how to use Excel as a calculator to perform basic arithmetic operations such as addition, subtraction, multiplication, and division.