I need to check my work.
Only use DAVERAGE, DCOUNT, DMAX, DSUM, DMIN functions if necessary.
| Make sure the Valuable worksheet is active and enter a nested logical function in the Comments column to display Highly Valuable if either condition is met: *The release date is on or before December 31, 1989, or *The sold-out status is Yes, the percentage increase in value is at least 500%, or the Edition Size was less than 400. Enter an empty text string if the two conditions are not met. Hint: You will need to nest two logical functions within the logical test argument. Use cell references to set all conditions. Copy the function down the column. |
| In cell N8, enter a database function to count the number of highly valuable pieces of artwork indicated in column K. Use the criteria in cells P2:P3 in your function. |
| In cell N9, enter a database function to average the estimated values (Est. Value) of highly valuable pieces of artwork indicated in column K. Use the criteria in cells P2:P3 in your function. In cell N10, enter a database function to total the estimate values (Est. Value) of the highly valuable pieces of artwork indicated in column K. Use the criteria in cells P2:P3 in your function. |
H 5 Sign in unsert Draw Page Layout Formulas Data Review View Power Pivot Tell me what you want to do share Home dx cut 2 Autosu E Wrap Text Calibri General Co Paste Conditional Format as Cel nsert Delete Format Sort & Find Clear Format Painter Formatting Table lter Select Clipboard Fon Alignment Number Editing N11. Conditions Criteria 3500 Maroo S 135 215 59.3% Edition size 400 Comments 2 A Christensen Character Cleverly Camouflaged 950 May-98 s 150 Yes s 1.550 920.0% %Increase 500% Highly valuable 3 ALawyer More than Adequately Attired 4 A Man and His DoE 250 Aug-08 s 525 yes s 710 35.2% 5 A Place of Her Aug 08 S 1.450 Yes s 2.220 s 3.1% 6 A Place of Her Own 7 After Clouds, Sun with Sometimes the Spirit Touches Us Porcela 1950 Aug-99 s 275 Yes s 420 52.7% Summary of Highly Valuable 450 Dec 08 S 395 612 54.9% Number of Artwork 1 I 8 All That She ad 9 All the World's a Stage 3000 Sep-00 225 Average Est. Value: 12.72 27s oct oo S 795 Yes S 1.037 30.4% Total Est value: 1.272 10 All the World's a Stage 11 Angel Unaware 12 Angel with Epaulet 650 Jan-07 s 165 177 7.3% 13 Angels of My Village 3000 Sep-s5 s 195 Yes s 209 7.25% 14 Balancing Act 950 Mar-98 s 150 Yes s 779 419.396 S Benedict 6 Cecelia 350 Sep-05 s 195 Yes s 635 225.6% 7 Cece 4500 Mar-s3 s 185 Yes s 744 302.2% 18 College of Magical Knowledge 500 Mar-93 s 425 yes s 775 82.496 19 College of Magical Knowledge (Remarque) Sep-02 20 20 20 C Around Fish versation 3500 oct 96 s 245 yes s 536 118.896 rt of he Fit 1000 oct se s 840 863 27% 22 Court of the Faeries: Believer's Etching Edition 375 Sep-08 s 495 693 40.026 23 Courtship 24 Dusk 850 oct 86 s 95 Yes s 1.303 1271.6% Highly valuable Valuable Database Ready H 5 Sign in unsert Draw Page Layout Formulas Data Review View Power Pivot Tell me what you want to do share Home dx cut 2 Autosu E Wrap Text Calibri General Co Paste Conditional Format as Cel nsert Delete Format Sort & Find Clear Format Painter Formatting Table lter Select Clipboard Fon Alignment Number Editing N11. Conditions Criteria 3500 Maroo S 135 215 59.3% Edition size 400 Comments 2 A Christensen Character Cleverly Camouflaged 950 May-98 s 150 Yes s 1.550 920.0% %Increase 500% Highly valuable 3 ALawyer More than Adequately Attired 4 A Man and His DoE 250 Aug-08 s 525 yes s 710 35.2% 5 A Place of Her Aug 08 S 1.450 Yes s 2.220 s 3.1% 6 A Place of Her Own 7 After Clouds, Sun with Sometimes the Spirit Touches Us Porcela 1950 Aug-99 s 275 Yes s 420 52.7% Summary of Highly Valuable 450 Dec 08 S 395 612 54.9% Number of Artwork 1 I 8 All That She ad 9 All the World's a Stage 3000 Sep-00 225 Average Est. Value: 12.72 27s oct oo S 795 Yes S 1.037 30.4% Total Est value: 1.272 10 All the World's a Stage 11 Angel Unaware 12 Angel with Epaulet 650 Jan-07 s 165 177 7.3% 13 Angels of My Village 3000 Sep-s5 s 195 Yes s 209 7.25% 14 Balancing Act 950 Mar-98 s 150 Yes s 779 419.396 S Benedict 6 Cecelia 350 Sep-05 s 195 Yes s 635 225.6% 7 Cece 4500 Mar-s3 s 185 Yes s 744 302.2% 18 College of Magical Knowledge 500 Mar-93 s 425 yes s 775 82.496 19 College of Magical Knowledge (Remarque) Sep-02 20 20 20 C Around Fish versation 3500 oct 96 s 245 yes s 536 118.896 rt of he Fit 1000 oct se s 840 863 27% 22 Court of the Faeries: Believer's Etching Edition 375 Sep-08 s 495 693 40.026 23 Courtship 24 Dusk 850 oct 86 s 95 Yes s 1.303 1271.6% Highly valuable Valuable Database Ready
