Excel Error Handling 1

[sandybam]

I have an Excel Spreadsheet with the following:

ScheduledTime(D):18900
ActualTime(G):17160
ScheduleAdherence(H):=IF(ISERROR(G6/D6)*100,"N/A",(G6/D6)*100)
MeetsGoal(I): I want to say if ScheduleAdherence is "N/A" or div/0! then "N/A", else if ScheduleAdherene is >= 98, "Yes", "No".

Any help would be greatly appreciated.

Thank you,
Sandy

 

[Wray69]

If I understand you correctly then this should work for you;

=IF(OR(ISERROR(H2),H2="N/A&quot,"N/A",IF(H2>=98,"YES","NO&quot)

Hope this helps.

Regards,

Wray

 

[sandybam]

Thank you so much for your quick response. I knew I had to use the And or Or but didn't know which or how to use.

Thank you!
Sandy