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!

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!

Thanks =)