This is step 13 in using functions and advanced functions in Excel. The Rubric below describes the required calculations to follow. Excel however does not complete the function entered correctly.

H 5 0 Instructions_NP_EX16_CS5-8a.docx - Word Picture lools File Home Insert Design Layout References Mailings Review View Format Tell me what you want to do Christian Price & Share 13. Andre has set a revenue goal of $20,000 for January, February, and April, when the organization has no fundraisers, and a revenue goal of $200,000 for March and May, when the organization does have fundraisers. In cell B10, enter a formula using the IF and AND functions to indicate whether the revenue goal has been met that month: a. Enter the logical test using the AND function to determine if the Fundraisers amount in cell B7 equals 0 and the Total in cell B8 is greater than 20000. b. If the logical test is true, display Yes (using "Yes" for the value_if_true argument). If the logical test is false, insert a nested IF function d. Enter the logical test of the nested IF function using the AND function to determine if the Fundraisers amount in cell B7 is greater than 0 and the Total in cell B8 is greater than 200000. e. If the logical test for the nested IF function is true, display Yes (using "Yes" for the value_if_true argument). f. If the logical test is false, display No (using "NO" for the value_if_false argument). Copy the formula in cell B10 to the range C10:F10. Page 3 of 12 2191 wards BEE - + 10% 1:12 PM NP_EX16_CS5-8a_Christian Price_2.xlsx - Excel Tell me what you want to do... File Home Insert Page Layout Formulas Data Review View Christian Price & Share B10 - X =IFANDIB7="0",88>20000),"Yes", IFIAND(87>"0",08>200000), "Yes","No"> Wild Planet Conservation Total Revenue - 2019 -MT Patron $ Sponsor $ Benefactor $ Fundraisers $ Total $ Jan 1,795 $ 4,075 $ 17,800 $ - $ 23,670 $ Feb 1,200 $ 2,100 $ 14,450 $ - $ 17,750 $ March 1,155 $ 9,550 $ 25,900 $ 192,750 $ 229,355 $ Apr 1,285 $ 12,450 $ 8,150 $ - $ 21,885 $ May Total 750 $ 6,185 7,300 35,475 7,500 73,800 193,900 386,650 209,450 $ 502,110 7 8 9 | 10 Goal met? No 11 No No No No 13 15 16 1 Documentation Local Offices California Oregon Washington Consolidated Spring Fall Ready 7 E I - + 1947 1:10 PM 7/23/2019