Author Topic: Flipping Subshape  (Read 4379 times)

0 Members and 1 Guest are viewing this topic.

Michelle

  • Full Member
  • ***
  • Posts: 151
Flipping Subshape
« on: August 06, 2008, 03:43:08 PM »
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

Visio Guy

  • Administrator
  • Hero Member
  • *****
  • Posts: 1737
  • Smart Graphics for Visual People...n' Stuff
    • Visio Guy
Re: Flipping Subshape
« Reply #1 on: August 06, 2008, 04:05:44 PM »
Hi Michelle,

You are close...

OR needs to wrap both conditions, ie:

IF( OR( condition_1, condition_2, condition_3, ...) , true_case, false_case )
For articles, tips and free content, see the Visio Guy Website at http://www.visguy.com
Get my Visio Book! Using Microsoft Visio 2010