Some Check Figures and Tips for Excel Assignment
Question
Check Figure for first Data Row
3
$490.00
Important: Note overall that the check figures are for the first row only. They do not guarantee that the formula is correct when you copy the formula down for each row in the table. You can check a sample of rows to make sure that your answers make sense. Notice when absolute cell references are required for the formula to remain accurate as it is copied down (e.g., to ensure ranges, arrays, sum ranges, etc. do not move).
For #9 column M:
=IF(OR(Something is True, Something else is True), Value if True, Value if False)
Notice that in the IF() you can tell Excel to return whatever value you want (no, yes, maybe, blue, anything…in any order). You can also use any criteria for “something is true”…such as based on being inside…or perhaps outside the range.
For #10 column N:
=IF(Something is True, then do something, otherwise do something else).
For the “then do something” you can tell Excel to check the second half of the true criteria in a nested IF(). So…
=IF(first half of the true criteria, IF(second half of the true criteria, then do something, otherwise do something else), otherwise do something else). So…
=IF (Something is True, IF(Something is True, “Yes”, “No”), “No”).
4
$465.50
5
Wilman Kala
6
2155
$26.22
51340
25%
$4.80
7
43
$16.38
1158
$200,944.24
8
No
9
Yes
Yes
10
Yes
11
No
12
No
13
2017
1
No
No
14
44,532
No
No
15
$196,039.56
16
Maria A
aria Anders
5
12
6
Maria
Anders
Pivot Table (17-20):
Pivot Table (21):