Scribd
Upload
73 views4 pages

Excel Errors

The document presents sales data for various customers, including current and previous year sales, along with changes in sales figures. It also lists common Excel errors, such as #DIV/0! and #VALUE!, providing brief descriptions of each error type. The information is useful for understanding sales performance and troubleshooting Excel formulas.

Uploaded by

jaibirmalik2023
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
73 views4 pages

Excel Errors

The document presents sales data for various customers, including current and previous year sales, along with changes in sales figures. It also lists common Excel errors, such as #DIV/0! and #VALUE!, providing brief descriptions of each error type. The information is useful for understanding sales performance and troubleshooting Excel formulas.

Uploaded by

jaibirmalik2023
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Customer Sales PY Name Sales

Maxim 2,500 1,900 Loco 2,800


Loco 2,800 Limbo Person doesn't exist
Limba 2,500 3,200 Tampay 2,500
Nadar 1,500 1,400
Tampay 2,500 2,400
Karlson 6,500 7,000
Customer Sales PY Change
Maxim 2,500 1,900 600
Loco 2,800 2,800
Limba 3,500 3,200 300
Nadar 1,500 1,400 100
Tampay 5,900 5900
Karlson 6,500 7,000 -500

Error Description
#DIV/0! This is probably the most common error and easiest to pinpoint. When you divide a number by zero you will get t
#VALUE! This error is returned when the wrong type of argument is used. For example if you try to multiply a value by a ce
#REF! This error results when you move your formulas and haven’t correctly specified which cells are fixed and which sh
#NAME? The most common reason for this error is because the formula has been mistyped and Excel doesn’t recognize wh
#N/A! This is a frequent error if you are using Lookup formulas (especially in VLOOKUP) and the matching cannot be don
#NULL! This is an uncommon error and occurs if you haven’t specified your ranges correctly, e.g. typing SUM(B4 B6) inste
#NUM! This is another uncommon error and occurs when you supply an invalid number to your formula e.g. if you are usi
de a number by zero you will get this error.
you try to multiply a value by a cell that has text in it.
which cells are fixed and which should move with your formula. Also if you delete some cells that were a part of your formula.
ed and Excel doesn’t recognize what function you are referring to.
) and the matching cannot be done.
ectly, e.g. typing SUM(B4 B6) instead of SUM(B4:B6) or SUM(B4,B6).
to your formula e.g. if you are using negatives where a positive number is required by your function.
rt of your formula.

You might also like