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.
------------------------------
The
How To Play Your DVD's
In Windows Media Player!
The DVD XPack instantly adds DVD playback to
Windows Media Player 9, 10 and 11. It Installs the
same theatre-quality video and audio decoders
proven by over 45 million users of WinDVD -
the world's leading software DVD player!
Why Use It? BECAUSE:
It's FAST, low-cost, easy to use AND Microsoft approved!
The
InterVideo DVD XPack
 Plugin
(The
above link not working?
Click Here )
NOW works with
Windows Vista too!
|
|
|
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
| 
