excel problem, using nested if functions

If an incorrect zip code is entered in cell B4, cells C6, C7, C8, and C9 will display the #N/A error value. Use the IFERROR function to modify the formula in these cells so that if the ID entered is not found, then the message Zip Code not found is displayed in the cell.

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:””;
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:”Times New Roman”;}

 

 

I am having trouble figuring out what to do for this question.  

By: Aleesha

Leave a Reply

Your email address will not be published. Required fields are marked *