AnsweredAssumed Answered

Boolean in Formula

Question asked by Woozie on Mar 16, 2011
Latest reply on Mar 24, 2011 by Woozie

Like • Show 0 Likes0
Comment • 3

Hello,

Is there a way to do an "If-then" statement in formula? I know I can do "If", but I'm not sure how to do "then".

For instance, I put A == "Apple"; A is input, and the result would either say TRUE or FALSE, but I want to use that result for further uses in the formula.

Any idea???

Thanks!

No one else has this question

Outcomes

3 Replies

Woozie Mar 17, 2011 5:29 AM
Mark Correct
Correct Answer
Hmmm.... A function inside a ( ), I'll give it a try and see what happens.

Thanks =)
Like • Show 0 Likes0
Actions
Woozie Mar 17, 2011 7:55 AM
Mark Correct
Correct Answer
Hmmm.... It doesn't seem to work in my case...

I tried to set a label's background color if the statement is true, or false. So my code is (a==b?label.BackColor = "Green":label.BackColor = "Yellow")

Everything seems fine except it tells me the "=" sign is a syntax error, but the only way that I know to change color with formula is label.BackColor = "color"......

Any more help?

Thanks!
Like • Show 0 Likes0
Actions
Woozie Mar 24, 2011 5:40 AM
Mark Correct
Correct Answer
Works, many thanks!
Like • Show 0 Likes0
Actions

Boolean in Formula

Outcomes

Related Content

Recommended Content