|Although some functions will correctly evaluate cells and ignore text strings, as a general rule for mathematical operations, both cells should have numbers, |
If your using arithmetic operators, plus sign, minus sign, etc.
try using a function instead
=SUM() for addition
=PRODUCT() for multiplication
=QUOTIENT() for division