HELP - Invalid number of arguments

[jgelpi16]

I need a second pair of eyes to look at this. I keep getting the error that I have an invalid number of arguments. I am trying to use this IF statement in a text box on a report. Thank you.

=iif(mid([EntityID],3,1) = "-", "XX-XXX" & Mid([EntityID],7,4), iif([mid([EntityID],4,1) = "-", "XXX-XX-" & Mid([EntityID],8,4),"XXXXX" & mid([EntityID],6,4))

[jzwp11]

I see an extra [ in the nested IIF() shown in red below, and you have a different amount of ( versus ) . You'll need to add 1 close ) as shown in magenta below.

iif(mid([EntityID],3,1) = "-", "XX-XXX" & Mid([EntityID],7,4), iif([mid([EntityID],4,1) = "-", "XXX-XX-" & Mid([EntityID],8,4),"XXXXX" & mid([EntityID],6,4)))

[jgelpi16]

Excellent. Thanks a lot!

[jzwp11]

You're welcome. I've pulled out my hair with some of those nested IIF() functions too!