Scribd
Upload
34 views6 pages

Cell Filename Sales 345.6 369 Info Osversion Info Directory Info System

The document contains sales, expense, and profit data for 6 months as well as yearly totals. It shows the monthly values as well as percentage changes. It also includes ratios of sales to expenses, sales to profits, and expenses to profits on a monthly basis. The second half of the document discusses Excel error functions like ISERROR, ISERR, IFERROR, and common error types like #N/A, #VALUE!, #REF!, and #DIV/0!.

Uploaded by

shahim akram
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
34 views6 pages

Cell Filename Sales 345.6 369 Info Osversion Info Directory Info System

The document contains sales, expense, and profit data for 6 months as well as yearly totals. It shows the monthly values as well as percentage changes. It also includes ratios of sales to expenses, sales to profits, and expenses to profits on a monthly basis. The second half of the document discusses Excel error functions like ISERROR, ISERR, IFERROR, and common error types like #N/A, #VALUE!, #REF!, and #DIV/0!.

Uploaded by

shahim akram
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
You are on page 1/ 6

CELL FILENAME

Sales
345.6
369
INFO OSVERSION
INFO DIRECTORY
INFO SYSTEM

ISTEXT ISNUMBER ISNONTEXT


3243
2337
29O2
34OI
25I6
2762
2942
26lO
2482
2789

Score Adjusted Score


217
632
543
-263
-842
700
882
203

usted Score

Sales
Expenses
Profits
YTD Profits

Jan
###
100.00
20.00
20.00

% Sales Change
% Expenses Change
% Profits Change

Feb
###
130.00
50.00
70.00

Mar
###
120.00
130.00
200.00

Apr
###
220.00
20.00
220.00

May
###
260.00
40.00
260.00

Jun
Total
###
###
350.00 1,180.00
100.00
360.00
360.00

50.0%
30.0%
150.0%

38.9%
-7.7%
160.0%

-4.0%
83.3%
-84.6%

25.0%
18.2%
100.0%

50.0%
34.6%
150.0%

Sales:Expenses
1.4
2.1
1.1
1.2
1.3
1.3
Excel Error-checking1.2
Functions
Sales:Profits
3.6types - 1.9
12.0
7.5 #DIV/0!,
4.5 #NUM!,4.3
ISERROR
checks 6.0
for all error
#N/A, #VALUE!,
#REF!,
#NAME?, or #NU
Expenses:Profits
2.6types except
0.9
11.0
6.5
3.5
3.3
ISERR
checks5.0
for all error
#N/A
IFERROR
returns a value you specify if a formula evaluates to an error; otherwise, returns the
formula
AGGREGATE (among other capabilities), lets you ignore error cells as you tabulate SUM, AVERAGE,
that contain these cells
Excel Formula Errors
#N/A
Indicates that a value is not available to a formula.
#VALUE! A formula variable is of the wrong type, i.e. text instead of value
#REF!
A formula contains an invalid cell reference
#DIV/0! Attempted division by zero
#NUM!
Invalid number, i.e. =SQRT(A1) when A1 is a negative number
#NAME? Unrecognized formula name
#NULL!
A reference to an intersection of two ranges that don't intersect

Average
###
196.67
60.00

30.3%
28.5%
38.0%

NUM!, #NAME?, or #NULL!


otherwise, returns the result of the

abulate SUM, AVERAGE, etc. for ranges

#N/A

Sales
Expenses
Profits
YTD Profits

Jan
Feb
Mar
Apr
May
Jun
###
###
###
###
###
###
100.00 130.00 120.00 220.00 260.00 350.00
25.00
50.00 130.00
20.00
40.00 100.00
25.00
75.00 205.00 225.00 265.00 365.00

% Sales Change
% Expenses Change
% Profits Change
Sales:Expenses
Sales:Profits
Expenses:Profi

1.3
5.0
4.0

44.0%
38.9%
30.0%
-7.7%
100.0% 160.0%
1.4
3.6
2.6

2.1
1.9
0.9

-4.0%
25.0%
50.0%
83.3%
18.2%
34.6%
-84.6% 100.0% 150.0%
1.1
12.0
11.0

1.2
7.5
6.5

1.3
4.5
3.5

You might also like