Hi All,

I am looking to adapt the following formula.

=IF(COUNTIF(R4:T4,"P")=COLUMNS(R4:T4),"Pass","")
At the moment this formula looks in the range and returns Pass if all cells contain P and if they are all blank nothing is returned. I was wondering if it was possible to make it if they are all blank no value is returned but if say if only one cell has P in it it returns the value fail.

Thanks

If you need any further information please let me know i will upload a example book if needed.