So, what exactly is a formula?
It is simply a statement made up of ‘operands’ and ‘operators’.
Say you want to calculate the 15% discount off of $20.
In this statement, there are two ‘operands’: price ($20) and discount percent (15%).
The operator is multiply (*).
‘Discount’ is the result.
Discount = $20 (price) * 15% (discount percent)
Now let’s see what our discount formula looks like in Excel.
Once you press enter, the formula will calculate the formula and show the result.
Note the formula shown in the box above the spreadsheet. This is the ‘formula bar’. More on that in a bit.
Now, look at the result if you input your formula without the equal sign.
Nothing seems to be any different aside from the missing equals sign in front of the actual formula.
Without the equal sign, it is just a string of text or numbers according to Excel.