Print Page - IF AND help

Title: IF AND help
Post by: jebuxx on September 14, 2017, 05:11:19 PM

Hello Visio heads. I am having a major brain fart again.
What is wrong with this formula?

=if(and(strsame(pages[Summary]!sheet.1579!Prop.FoldClass,"Unwind 4", strsame(pages[Data]!sheet.222!Prop.Fold Type","SF-07","PANEL 5"),""))

So when sheet 1579 says "Unwind 4" and sheet 222 says "SF-07" I need the targeted sheet to say PANEL 5.

What am I doing wrong?

thank you.. Jim

Title: Re: IF AND help
Post by: wapperdude on September 14, 2017, 05:20:06 PM

=if(and(strsame(pages[Summary]!sheet.1579!Prop.FoldClass,"Unwind 4"), strsame(pages[Data]!sheet.222!Prop.Fold Type","SF-07")),"PANEL 5","")

wapperdude

Title: Re: IF AND help
Post by: jebuxx on September 14, 2017, 05:51:25 PM

thanx Wapperdude, however is the an extra " after the Prop.Fold Type?

Title: Re: IF AND help
Post by: wapperdude on September 14, 2017, 05:55:27 PM

As I read the line, needed parenthesis to close 1st strsame, needed next parenthesis to close 2nd strsame, then another parenthesis to close the "and", and finally, of course, a single parenthesis to close the "IF".

Did not test in Visio.

Ooops. The extra " is a typo. My bad!

Wapperdude

Edit: wait! that extra " was part of original equation. Please revise "my bad" to "your bad"...LOL

Title: Re: IF AND help
Post by: jebuxx on September 14, 2017, 06:42:24 PM

A few slight changes and it works. Thanx a ton!!!

=IF(AND(STRSAME(Pages[Summary]!Sheet.222!Prop.ES,"SF-07"),STRSAME(Pages[Summary]!Sheet.1579!Prop.Unwind,"UNWIND 4",)),"Panel 4","")

Title: Re: IF AND help
Post by: wapperdude on September 14, 2017, 06:51:54 PM

Seems like there's an extra comma, just before the double parentheses.

Wapperdude

Visio Guy

Visio Discussions => General Visio => Topic started by: jebuxx on September 14, 2017, 05:11:19 PM