If Statement Range

  • Thread starter Thread starter TONYC
  • Start date Start date
T

TONYC

The following if statement works fine on a single cell “AO5” -

=IF(AP5<>"","PASS","")

However, I want to be able to say that if there is any data in cell
AP5 to BL5, excluding the word 'FAIL', then enter 'PASS' in cel
“AO5”.

Ton
 
Hi
try
=IF(SUMPRODUCT(--(AP5:BL5<>"FAIL"),--(AP5:BL5<>"")),"Pass","")
 
One Way,
=IF(COUNTA(AP5:BL5)=0,"",IF(COUNTIF(AP5:BL5,"Fail")>0,"Fail","Pass"))
Regards,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating text as values in a row 3
question using visual basic 1
formula is too long error 3
Sum and Counta function in Listbox for UserForm 2
Macros for copy and paste of a range 11
VBA Sumif *********************** Help 2
If statement for a range of cells 3
If statement 1

Back
Top