View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] RoniMurphy@gmail.com is offline
external usenet poster
 
Posts: 2
Default Nested If statements

Can you help please?

I have a table where each student has sat 2 papers. If they get 50 or
over it is a pass, if they get 80 or more they distinction and if they
get less then 50, it is a fail. This works fine if they pass or fail
both papers, however if they fail one but get a distinction in the
other, my formula is not working.

thank you

Roni