CAN SOME HELP ME HOW TO PUT THIS FORMULA ON EXCEL: 1. Andre has set a revenue go

Question

CAN SOME HELP ME HOW TO PUT THIS FORMULA ON EXCEL:

1.        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:

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.

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.

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.

If the logical test for the nested IF function is true, display Yes (using “Yes” for the value_if_true argument).

If the logical test is false, display No (using “No” for the value_if_false argument).

Explanation / Answer

=IF(AND(B7=0,B8>20000),"Yes",IF(AND(B7>0,B8>200000),"No",[What to do if both Ifs are false]))

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.