Calculations with Tickboxes

[HPage]

How do you use tickbox entries in calculations? For instance, Say I have a tick box with 5 values, (Eg. A, B, C, D,E) and I want to use an "if" statement with them. I want the result of the statement to be true if A is selected, but any of the other values can be selected with A, it still stays true. So far I used If(TickboxField ="A"; blah blah), It works If A is the only option selected. How do I make it work so that any other options can be selected with A?

Edited September 13, 2006 by Guest

[Lee Smith]

The Case function to me is easier to use, this is not tested, but it should be correct.

Case(

TickboxField = "A"; "blah";

Tickboxfield = "B"; "blab";

Tickboxfield = "C"; "you get the idea")

HTH

Lee

[HPage]

Yes thankyou, that is easier to use, but It still does not solve my problem. I will try to make myself more clear. If A is selected, the expression must be true, nevermind if B or C ect is selected with A. At the moment the expression is true when A is selected, but the moment I select something else with A it does not work.

[Raybaudi]

Case(

PatternCount(TickboxField;"A");1;

0

)

[HPage]

Thanks a million, that did the trick!