Excel #Value
Error
Article Published 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.
|
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.
------------------------------
Microsoft Excel Function & Formulas Explained!
PART 1:
The 81 page guide starts off by explaining what formulas and functions
are, then moves onto dealing with typical errors you may encounter and
how to remedy them. Then finally shows you how to confidently use 20 of
the most essential formulas! (For example SUM, IF, SIGN, SUMIF, AVERAGE,
FLOOR and COUNT to name a few)
PART 2:
The 51 page guide picks up the pace and takes you through more advanced
formulas and functions that every Microsoft Excel power user NEEDS to
know! Including how to use nested IF statements!
Buy Part 1 and get Part 2 FREE!
Find Out More Here:
Microsoft Excel Formula's and Function's
|
|
|
If you have found
this article excel value errors useful, then why not sign up for my
FREE Windows XP Newsletter service?
Enjoy the rest of site and
remember if you have a query about this site or a comment to make
then drop me a line at the
Contact Page
|
Kind Regards
Marc Liron -
Bio
Microsoft MVP
Your Guide to using Windows XP
A Unique Windows XP Newsletter?
Sign Up Now!
- Make sure you get your
FREE tips and advice...
Other Websites By Marc Liron - Microsoft MVP
News and Articles on Windows Vista:
www.instantvista.com
My Techie Blog:
www.marclironblog.com
My Windows Technology Newsletter
www.marctalkstech.com
|
