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

 

[texasalynn]

If the first cell is empty and data is in the second and third no pass/fail is given.

so you had a secondary qualifier and now you say no only the first cell qualifies???? Please show manually (no formula) the given results you are expecting

 

[TBLO]

No, I want each of the 3 cells to meet the pass/fail criteria of <=5. If all the cells are blank I want the reporting cell to be blank as well instead of defaulting to Pass. The formula below works except if there is no data in cells E14,F14,or G14 the cell displays Pass......

=IF(AND(E14<=5,F14<=5,G14<=5),"Pass","Fail")

 

[texasalynn]

maybe?

=IF(AND(E14<=5,F14<=5,G14<=5),"",IF(AND(E14<=5,F14<=5,G14<=5),"Pass","Fail"))

 

[TBLO]

YES! YES!! YES!!!
With the minor change it works!
I've been racking my brain on this stupid thing for 2 days!
THANKS SO MUCH! MAY you have a fantastic weekend!

=IF(AND(E14=0,F14=0,G14=0),"",IF(AND(E14<=5,F14<=5,G14<=5),"Pass","Fail"))

TBLO

 

[T. Valko]

YES! YES!! YES!!!
With the minor change it works!
I've been racking my brain on this stupid thing for 2 days!
THANKS SO MUCH! MAY you have a fantastic weekend!

=IF(AND(E14=0,F14=0,G14=0),"",IF(AND(E14<=5,F14<=5,G14<=5),"Pass","Fail"))

TBLO

Assuming that the values entered must be greater than 0, this does the same thing and is a few keystrokes shorter.

=IF(SUM(E14:G14),IF(MAX(E14:G14)>5,"Fail","Pass"),"")

 

[TBLO]

T.Valko,
No this doesn't work either because it's not the sum of all the cells. Each cell can have a different value and the pass/fail criteria dependant on each individual cell. Thanks though, I appreciate it.