The Excel value error
Excel Value Error
Article by Marc Liron - Microsoft MVP
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 - Hands On Guide!

Microsoft Excel Functions And Formulas Guide
Discover more about using Functions and Formulas -
CLICK HERE!
...for 2003 / 2007 and 2010
-----------------------------------------------------------------------------------------------------------
Trouble Free Computing?

CLICK
HERE
- For More Information Now!
-----------------------------------------------------------------------------------------------------------
>>> My FREE Windows Newsletter! >>>
Claim YOUR Fortnightly copy of my FREE Windows Newsletter covering:
Windows XP, Windows Vista, Windows 7 , Microsoft Office and Windows Live Services - Sign-up TODAY!!!
Enjoy!
Kind Regards

Marc Liron - Microsoft MVP
www.marcliron.com
www.twitter.com/marcliron
http://blog.marcliron.com
Links
Trouble Free Computing?
"Discover The Simple But
Powerful Secrets To Keeping Out Viruses, Hackers, Trojans,
Keyloggers And Many Other Online Security Threats"
Expert PC security advice from a long
standing Microsoft MVP!
--------------------
Related Articles:
Understanding Excel Dates and Times
Excel 2003 Vs Excel 2007 - What's New in Excel 2007
Calculate the Coefficient of Variation in Excel
5 Excel Mortgage Amortization Formulas
How to Wipe and Clean Excel Spreadsheets Thoroughly
Calculate Weighted Average in Excel


