Missing parenthesis

**docrobo** · 10-23-2011, 04:29 PM

=IF(OR(EZ12={"WIN","SEQUENCE END"},EU12*EW12/EY12,IF(EZ12="POSTPONED",0,-EU12))

When trying to save the above formula I am getting an error message saying their is a parenthesis missing. I am struggling to workout where the parenthesis should be.

Can anyone help?

**zbor** · 10-23-2011, 05:01 PM

Here: =IF(OR(EZ12={"WIN","SEQUENCE END"}),EU12*EW12/EY12,IF(EZ12="POSTPONED",0,-EU12))

**zbor** · 10-23-2011, 05:06 PM

And this can be another approach.. Just easier to add new criterias...

=IF(ISERR(MATCH(EZ12,{"POSTPONED","SEQUENCE END","WIN"},0)), -EU12, EU12*CHOOSE(MATCH(EZ12,{"POSTPONED","SEQUENCE END","WIN"},0),0,EW12/EY12,EW12/EY12))