Too many arguments?

[DanL77]

Hi, I'm trying to complete a formula which uses criteria to set a red, amber or green status. The rule I want to create is:

> If there are any blanks, show blank
> If all selected cells are Yes, show green
> If there are any "no" cells, show red
> For all else, show amber

Here's the formula I'm trying and being told there are too many arguments. Any help appreciated.

Thanks

Dan

=if(or(isblank(C5,D5,E5,F5,G5)),"",if(and(C5=C20,D5=D20,E5=E20,F5=F20,G5=G20),"Green",if(or(C5=C21,D5=D21,E5=E21,F5=F21,G5=G21),"Red","Amber"

 

[wideboydixon]

Book1
	C	D	E	F	G	H
5	Yes	Maybe	Yes	Maybe	Yes	Amber
6	Yes	Yes	Yes	Yes	Yes	Green
7	No	No	No	No	No	Red
8	Yes		No		Yes
9	Yes	Maybe	Maybe	Yes	No	Red
10
11
12
13
14
15
16
17
18
19
20					Yes
21				No
Sheet1

Cell Formulas
Range	Formula
H5	=IF(COUNTA($C5:$G5)<5,"",IF(COUNTIF($C5:$G5,$G$20)=5,"Green",IF(COUNTIF($C5:$G5,$F$21)>0,"Red","Amber")))

WBD

 

[AlanY]

you need to change or(isblank(C5,D5,E5,F5,G5) to

or(isblank(C5),isblank(D5),..etc)