excel value error

The Excel value error

Download

 

Excel Value Error

 



 

 

In Microsoft Excel, when you perform a mathematical operation on cells that contain text and values, you may receive a #VALUE! error..

(If you are looking for an example of how to use the Excel IF Value - click here.)

 

 

Although some functions correctly evaluate cells and ignore text strings, if you add the cells by using arithmetic operators such as:

Addition (+)
Subtraction
(-)
Multiplication
(*)
Division
(/)

...an error value may occur.

Instead of using an individual mathematical operator, use its equivalent worksheet function instead:

SUM (adds)
PRODUCT (multiplies)
QUOTIENT (divides)

For example, if you type the following information in cells A1:A7 of a worksheet

A1: 10
A2: text
A3: 20

A4: =A1+A2+A3 - incorrect
A5: =SUM(A1+A2+A3) - incorrect

A6: =SUM(A1,A2,A3) - correct
A7: =SUM(A1:A3) - correct


...the formulas in cells A4 and A5 return a #VALUE! error; however, cells A6 and A7 return the correct value of 30.


Grab a Copy of My Excel F and F - Hands On Guide!

Microsoft Excel Guide

Microsoft Excel Functions And Formulas Guide

Discover more about using Functions and Formulas

...for 2003 / 2007 and 2010

NOW part of the following:

 

 

Enjoy!

Kind Regards

Marc Liron

Marc Liron - Microsoft MVP (2004-2010)
www.marcliron.com
www.twitter.com/marcliron
http://blog.marcliron.com

Download

 

Links