IF(logical_test; value_if_true; value_if_false)

[Alex Moon]

Right Click on ShapeSheet > "Show ShapeSheet"
Win:"Custom Poperties" change Prop.Status "on" and "off"
Win:"Line Format" Row "LineColor" i write:
=IF(Prop.Status.Value="on";0;2)
MSViso: Error in Formula
help me plz...

 

[Philippe C.]

I should not answer without trying first, but I suppose "On" should be numeric.

 

[John Goldsmith]

Hello Alex,

You need to use the STRSAME function for string comparisons so try your
formula as follows:

=IF(STRSAME(Prop.Status.Value,"on"),0,2)

You might also want to consider the LOOKUP function as well. Take a look at
this post:

http://groups.google.co.uk/group/mi...custom+property&rnum=2&hl=en#e3839259ae142f8a

Best regards

John


John Goldsmith
www.visualSignals.co.uk

 

[Alex Moon]

Hello Alex,

You need to use the STRSAME function for string comparisons so try your
formula as follows:

=IF(STRSAME(Prop.Status.Value,"on"),0,2)

Thanks big, has helped!