=IF(EZ12="WIN",EU12*EW12/EY12,IF(EZ12="POSTPONED",0,-EU12))
I have the above formula and I am wanting to ad the words "SEQUENCE END" to the formula so that it calculates the same as the word "WIN"
Can anyone help.
Last edited by docrobo; 10-24-2011 at 07:14 PM.
Try using OR....
=IF(OR(EZ12={"WIN","SEQUENCE END"},EU12*EW12/EY12,IF(EZ12="POSTPONED",0,-EU12))
Audere est facere
I have pasted the formula in to the spreadsheet but when saving it I am getting an error that a parenthesis is missing.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks