IF formula for several cells in a row

Microsoft Office excel 2007 home & stude...
September 14, 2010 at 14:14:07
Specs: Windows 7
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.

See More: IF formula for several cells in a row

Report •

#1
September 14, 2010 at 14:20:32
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


Report •
Related Solutions


Ask Question