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).