Computer software forums just aren't as good as the good old LRC - so hopefully you can help me:
I'm operating Visio 2007 and cannot get an IF() function to work with shape data containing text values.
For a given shape I have 2 pieces of shape data (Prop.Row_1 and Prop.Row_2). I want the value of Prop.Row_2 to be an IF() style function based on the value of Prop.Row_1 - both values are intended to be letters/words as opposed to numerical. In the shapesheet I used the following equation as the value of Prop.Row_2:
=IF(Prop.Row_1="A","B","C") ...but it isn’t working correctly. The same style function works correctly with numerical values [=IF(Prop.Row_1="1","2","3")]
Thanks!