View Single Post
  #1   Report Post  
Raven Raven is offline
Junior Member
 
Posts: 1
Default Help with nested IF statement

Hi - I'm hoping someone can help me with a nested IF statement:
IF any one of cells A1 to A4 contain an "F" or an "I", then return an "F". Also, if any one of the cells A1 to A4 contain a "P" or an "H", then return a "P".

thank you!