News:

Happy New Year!

Main Menu

Flipping Subshape

Started by Michelle, August 06, 2008, 08:43:08 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Michelle

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

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

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 161 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1057KB.
Tokens: post-login.
Cache hits: 15: 0.00292s for 26,544 bytes (show)
Cache misses: 5: (show)
Queries used: 18.

[Show Queries]