I need to flip a sub shape based on a user's choice in the Shape Data. The user has 4 choices in a pull down, and I need two of them to produce a flip, and the other two not to produce a flip...
Here's one of my feeble attempts:
FlipY=IF(STRSAME(Sheet.5!Prop.PortOpening1,("Back"),OR(STRSAME(Sheet.5!Prop.PortOpening1,("Left")))),TRUE,FALSE)
This only produces the desired result if the user chooses "back". I also need the flip to happen if the user chooses "left".
Thank you,
Michelle