I have to write a nested if statement for the sam 2010 project 4. The requests i

Question

I have to write a nested if statement for the sam 2010 project 4. The requests is as following:

In cell E12, use nested IF functions to display the shipping costs for the option entered in cell C12.

a)      The first test should determine if the shipping option in cell C12 is blank, and if so, then cell E12 should also be blank.

b)      The second nested IF should test if C12 is equal to the shipping option in H3, and if so, then the value in I3 should be used.

c)      The third nested IF should test if C12 is equal to the shipping option in H4, and if so, then the value in I4 should be used.

d)      The fourth nested IF should test if C12 is equal to the shipping option in H5, and if so, then the value in I5 should be used. Otherwise,

Explanation / Answer

=IF(B12,IF(AND(E12,I12),"desirable",IF(OR(E12,I12),"potential")),IF(OR(E12,I12),"potential","unacceptable"))

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects