This article was previously published under Q100825
In Microsoft Excel, when you perform a mathematical operation on cells that contain text and values, you may receive a #VALUE! error.
Although some functions correctly evaluate cells and ignore text strings, if you add the cells by using arithmetic operators such as addition (+), subtraction (-), multiplication (*), or division (/), an error value may occur.
Instead of using an individual mathematical operator, use its equivalentworksheet function instead:
SUM (adds) PRODUCT (multiplies) QUOTIENT (divides)
For example, if you type the following information in cells A1:A7 of a worksheet