error in iif formula

route217
route217 used Ask the Experts™
on
Hi Experts

I cannot see my error here.....

Status: iif(Step 10 Status="Closed", Step 10 Name,iif(Step 9 Status="Closed", Step 9 Name,iif(Step 8 Status="Closed", Step 8 Name,iif(Step 7 Status="Closed", Step 7 Name,iif(Step 6 Status="Closed", Step 6 Name,iif(Step 5 Status="Closed", Step 5 Name,iif(Step 4 Status="Closed", Step 4 Name,iif(Step 3 Status="Closed", Step 3 Name,iif(Step 2 Status="Closed", Step 2 Name,iif(Step 1 Status="Closed", Step 1 Name,"Auto-rejected")
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
omgangIT Manager
Commented:
What is Step 10 Name, Step 9 Name, etc.?  What error are your receiving?
OM Gang
Commented:
The amount of closing brackets?
route217Junior

Author

Commented:
The expression you have entered is missing a parenthesis, bracket([), or vertical bar(|)
route217Junior

Author

Commented:
Many thanks experts nailed it
Paul JacksonSoftware Engineer
Top Expert 2011

Commented:
You open a lot of brackets but have no closing brackets :

Status: iif(Step 10 Status="Closed", Step 10 Name,iif(Step 9 Status="Closed", Step 9 Name,iif(Step 8 Status="Closed", Step 8 Name,iif(Step 7 Status="Closed", Step 7 Name,iif(Step 6 Status="Closed", Step 6 Name,iif(Step 5 Status="Closed", Step 5 Name,iif(Step 4 Status="Closed", Step 4 Name,iif(Step 3 Status="Closed", Step 3 Name,iif(Step 2 Status="Closed", Step 2 Name,iif(Step 1 Status="Closed", Step 1 Name,"Auto-rejected"))))))))))

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial