IF AND help

[jebuxx]

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

[wapperdude]

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

wapperdude

[jebuxx]

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

[wapperdude]

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

[jebuxx]

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","")

[wapperdude]

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

Wapperdude