Too Many arguments. What am I missing???

[TBLO]

I am trying to keep a "Pass","Fail" cell empty or blank until any one of the cells meets <=5.
=IF(ISBLANK(E19,F19),G19),"",IF(E19:G19<=5,"Pass","Fail"))
Any ideas?
Thanks,
T

 

[njimack]

=IF(COUNTA(E19:G19)=COLUMNS(E19:G19),IF(COUNTIF(E19:G19,"<="&5),"Pass","Fail"),"")

 

[T. Valko]

I am trying to keep a "Pass","Fail" cell empty or blank until any one of the cells meets <=5.
=IF(ISBLANK(E19,F19),G19),"",IF(E19:G19<=5,"Pass","Fail"))
Any ideas?
Thanks,
T

Maybe this is what you had in mind:

=IF(COUNT(E19:G19)=0,"",IF(COUNTIF(E19:G19,"<=5"),"Pass","Fail"))

 

[texasalynn]

Welcome to MrExcel board...

is this what you want?

Excel Workbook
	M
5
Sheet1

Excel 2003

Cell Formulas
Range	Formula
M5	=IF(OR(ISBLANK(E19),ISBLANK(F19),ISBLANK(G19)),"",IF(SUM(E19:G19)<=5,"Pass","Fail"))

if not then post a sample of your data

 

[TBLO]

Thanks Neil,
But that doesn't work. I need any one of the 3 cells to meet a pass fail criteria. =IF(AND(E14<=5,F14<=5,G14<=5),"Pass","Fail") This works except when E14, F14, G14 are empty the cell used to report defaults to Pass and I would like it blank.
T

 

[njimack]

Thanks Neil,
But that doesn't work. I need any one of the 3 cells to meet a pass fail criteria. =IF(AND(E14<=5,F14<=5,G14<=5),"Pass","Fail") This works except when E14, F14, G14 are empty the cell used to report defaults to Pass and I would like it blank.
T

Maybe this:

=IF(COUNTA(E19:G19)=COLUMNS(E19:G19),IF(COUNTIF(E19:G19,"<="&5)=COLUMNS(E19:G19),"Pass","Fail"),"")

 

[texasalynn]

Thanks Neil,
But that doesn't work. I need any one of the 3 cells to meet a pass fail criteria. =IF(AND(E14<=5,F14<=5,G14<=5),"Pass","Fail") This works except when E14, F14, G14 are empty the cell used to report defaults to Pass and I would like it blank.
T

did the other two suggestions not work either?

 

[TBLO]

The issue with all of these formula's is that the first of the 3 cells being evaluated controls the pass/fail. If the first cell is empty and data is in the second and third no pass/fail is given.

 

[texasalynn]

like this maybe

=IF(AND(ISBLANK(E19),COUNTA(F19:G19)=2),"",IF(SUM(E19:G19)< =5,"Pass","Fail"))

 

[TBLO]

Sorry, again the first cell controls the posting of the pass/fail criteria, and f & g cells function together.