Index of a Fixed List (Visio 2007)

[MikeM]

I have a fixed list, Prop.Sex, with format "M;F". I want to change the value
of another cell based on Prop.Sex. I type in
"=IF(Prop.Sex="F",2,4)"
and I get 2 regardless of the value of Prop.Sex. I've tried
"=IF(Prop.Sex=INDEX(1,Prop.Sex.Format),2,4)"
and get the same result. What am I doing wrong?

TIA
Mike

 

[John Goldsmith \(Visio MVP\)]

Hello Mike,

If you're testing for string equality then you need to use the strsame
function. Have a go with this instead:

=IF(STRSAME(Prop.Sex,"F"),2,4)

Hope that helps.

Best regards

John


John Goldsmith (Visio MVP)
www.visualSignals.typepad.co.uk
www.visualSignals.co.uk

 

[MikeM]

John,

Muchissimas gracias!

Mike

Hello Mike,

If you're testing for string equality then you need to use the strsame
function. Have a go with this instead:

=IF(STRSAME(Prop.Sex,"F"),2,4)

Hope that helps.

Best regards

John


John Goldsmith (Visio MVP)
www.visualSignals.typepad.co.uk
www.visualSignals.co.uk