ExcelBanter - Help with nested IF statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Help with nested IF statement (https://www.excelbanter.com/excel-worksheet-functions/267471-help-nested-if-statement.html)

Raven

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!

All times are GMT +1. The time now is 02:20 PM.