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 20,000. b If the logical test is true, display Yes (using "Yes" for the value_if_true argument). c. 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 determin if the Fundraiser amount in cell B7 is greater than 0 and the Total in cell B8 is greater than 200,000. 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 if false, display No (using "No" for the value_if_false argument) I have tried to figure this excel formula out for about an hour now, this is what I have. but this is only half of the formula. I need the correct formula please.

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 20,000.

Get your paper done on time by an expert in your field.

Order Now

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

c. 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 determin if the Fundraiser amount in cell B7 is greater than 0 and the Total in cell B8 is greater than 200,000.

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 if false, display No (using “No” for the value_if_false argument)

I have tried to figure this excel formula out for about an hour now, this is what I have. but this is only half of the formula. I need the correct formula please.

=IF(AND(B7=0,B8>20000),”Yes”,”No”)

Looking for someone to write your essay in 2 hours? Assignment123 can help. Hire an expert writer to tackle your essay paper and get it done quickly and efficiently. You can also order a custom essay, buy essay online, or get essay help from our team of experienced writers.

Turn in your highest-quality paper
Get a qualified writer to help you with

“ 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 20,000. b If the logical test is true, display Yes (using “Yes” for the value_if_true argument). c. 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 determin if the Fundraiser amount in cell B7 is greater than 0 and the Total in cell B8 is greater than 200,000. 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 if false, display No (using “No” for the value_if_false argument) I have tried to figure this excel formula out for about an hour now, this is what I have. but this is only half of the formula. I need the correct formula please. ”

Get high-quality paper

NEW! AI matching with writer

Need Help?

We are here to help.