Hello!
I was wondering how i could adapt the IF formula to look in 3 cells to see if they have the letter P and if all cells have the letter P the formula returns the value Pass in a specific cell.
I am currently using the formula below and it does not return Pass if there are P's in all of the cells.
I hope some one can help!
Please Login or Register to view this content.
Try changing ROWS to COLUMNS
Almost. Try
=IF(COUNTIF(AU12:AW12,"P")=COLUMNS(AU12:AW12),"Pass","Failed")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Replace the ROWS function with the COLUMNS function.
=IF(COUNTIF(AU12:AW12,"P")=COLUMNS(AU12:AW12),"Pass","Failed")
Or, you could just use 3:
=IF(COUNTIF(AU12:AW12,"P")=3,"Pass","Failed")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Trust it to be something so simple!
Rookie Mistake!
Thanks for your help!
Another way without having to know or calculate how many cells are involved...
Array entered**:
=IF(AND(AU12:AW12="P"),"Pass","Failed")
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Could i adapt this formula so that if there is one it says for example half complete or semi complete
=IF(COUNTIF(AU12:AW12,"P")=ROWS(AU12:AW12),"Pass","Failed")
So if NONE are P, then "Failed"
If SOME but not ALL are P, then "Semi Complete"
If ALL are P, then "Pass"
?
Try
=IF(COUNTIF(AU12:AW12,"P")=COLUMNS(AU12:AW12),"Pass",IF(COUNTIF(AU12:AW12,"P")=0,"Failed","Semi Complete"))
Thanks JonMo1 big help!Originally Posted by Jonmo1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks