567.
80 address
col
color
contents
filename
format
parentheses
prefix
protect
row
type
width
INFO DIRECTORY
INFO NUMFILE
INFO ORIGIN
INFO OSVERSION
INFO RECALC
INFO RELEASE
INFO SYSTEM
$A$1
'[Link]
,1
Linux 5.10
Automatic
47eb0cf7efbacdee9b19ae25d6752381ede23126
LINUX
5:00 AM G
31-Jan-20 G
2/14/2021 G
23.4 F0
3,456.40 ,2()
₹ 23.40 C2
987.400 ,3
$23.40 ,2-()
India ,2
9 F0
ISTEXT ISNUMBER ISNONTEXT
3243 0 1 TRUE
2337 FALSE TRUE TRUE
29O2 TRUE FALSE FALSE
34OI TRUE FALSE FALSE
25I6 TRUE FALSE FALSE
2762 FALSE TRUE TRUE
2942 FALSE TRUE TRUE
26lO TRUE FALSE FALSE
2482 FALSE TRUE TRUE
2789 FALSE TRUE TRUE
Score Adjusted Score
217 217 TRUE TRUE
632 632 TRUE TRUE
99 TRUE TRUE
543 543 TRUE TRUE
99 TRUE TRUE
-263 -263 TRUE TRUE
-842 -842 TRUE TRUE
99 TRUE TRUE
700 700 TRUE TRUE
99 TRUE TRUE
882 882 FALSE FALSE
203 203 FALSE FALSE
Jan Feb Mar Apr May
Sales $ 120.00 $ 180.00 $ 250.00 $ 240.00 $ 300.00
Expenses 100.00 130.00 120.00 210.00 260.00
Profits 20.00 50.00 130.00 30.00 40.00
YTD Profits 20.00 70.00 200.00 230.00 270.00
% Sales Change 50.0% 38.9% -4.0% 25.0%
% Expenses Change 30.0% -7.7% 75.0% 23.8%
% Profits Change 150.0% 160.0% -76.9% 33.3%
Excel Error-checking Functions
ISERROR checks for all error types - #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #N
ISERR checks for all error types except #N/A
IFERROR returns a value you specify if a formula evaluates to an error; otherwise, retu
AGGREGATE (among other capabilities), lets you ignore error cells as you tabulate SUM, AVERAGE
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
Jun Total Average
$ 450.00 $ 1,540.00 $ 256.67 #N/A
350.00 1,170.00 195.00
100.00 370.00 61.67
370.00
50.0% 30.3%
34.6% 28.5%
150.0% 38.0%
IV/0!, #NUM!, #NAME?, or #NULL!
to an error; otherwise, returns the result of the formula
s you tabulate SUM, AVERAGE, etc. for ranges that contain these
value
mber
tersect
Weight / M ? 140
Length (inches) ? 66.00 PRICE USD
Per pound price $ 0.340
Freight ? $ 0.262
Freight = $ (0.262)
Qty per 40' cntr = 56,299 C&F =
# of plts ? 17 Load Qty ?
Info TL's
Pieces / skid = 3,311.69 Round TL's
# of plts ? 18 Round QTY
Net Wt. Gros Wt.
Pieces / skid = 3,127.71
Mixed/combination loads
Weight A Weight B
Wt/M ? 140 Wt/M ? 140
Length ? 72 Length ? 66
Qty ? 12,144 Qty ? 43,056
Net = 10,200.96 Lbs Net = 33,153.12
Weight C Weight D
Wt/M ? 190 Wt/M ? 190
Length ? 26.25 Length ? 24.5
Qty ? 8,000 Qty ? 3,000
Net = 3,325.00 Lbs Net = 1,163.75
Weight E Weight F
Wt/M ? 160 Wt/M ? 160
Length ? 21.25 Length ? 27.75
Qty ? 4,000 Qty ? 14,000
Net = 1,133.33 Lbs Net = 5,180.00
Weight G Weight H
Wt/M ? 160 Wt/M ? 160
Length ? 26.25 Length ? 24.5
Qty ? 8,000 Qty ? 3,000
Net = 2,800.00 Lbs Net = 980.00
% FOB C&F
1 $ 0.2644
TL Cx 2 $ 0.2566 $ (0.005) cm
3 $ 0.2618 $ -
Cntr cost $ 19,095 4
Per unit freight cost 5 inches
Incl. freight $ - 6
74,426 7 $ 0.2618 $ -
1.32 8 Px
2.00 9 $ 0.2618 $ - Qty
10 $ 0.2618 $ - $ Amt
11 $ 0.2618 $ - $ Amt
112,597 12 $ 17.0618 $ 16.800
13 $ 8.8418 $ 8.580
14 $ 6,028.1018 $ 6,027.840
15 $ 4,973.2298 $ 4,972.968
Lbs 43,354 (A+B) per piece
per 1000
enter pallet qty
pcs per plt
weight per plt
Lbs 4,489 (C+D)
Total wt. 47,843 TOTAL 58,049
Lbs 6,313 (E+F)
Lbs 3,780 (G+H)
Total wt. 10,093
Conversions
Metric US
200 78.74 in
US Metric
0.185 0.47 cm
Order Information
$ 0.262 each
74,426 pcs
$ 19,485 Net
$ - Gross
Weights
- Lbs
- Lbs
17 plts
3,312 pcs
- Lbs
58,049