I have a spreadsheet tracking how many units a student has passed (several cells in one row). How do I get a 'FINAL RESULT' cell to report "P" when all cells in the range report "P"? I have tried the IF formula but this only provides 2 criteria or data cells.

Hi, If you are looking to test if several cells contain "P", try AND()

=IF(AND(A1="P",A2="P",A3="P"),"P","not all P")

Regards

Ask Your Question

Weekly Poll