How To create IF AND OR formula

[twkyoscr]

Trying to create a formula in Crystal 8.01 that is basically this:

if a = 0
and b=c or b = d then "Text" else
remaining formula

I am abel to do if and statements but I need the if and or. Any thoughts?

Thanks!

 

[lbass]

It depends on whether you mean:

(a = 0 and b=c) or b=d

or

a = 0 and (b=c or b=d)

I'm guessing you mean the latter. You don't really need to use the "or," in that case. The formula could instead be:

if a = 0 and
b in [c,d] then
rest of your formula

If you mean the first case, then be sure to use parens.

-LB

 

[synapsevampire]

Nothing prevents you from doing this, or is supported

But you haven't identified what you mean in your OR, and I don't think that you really need an OR, try:

if a = 0
and
b in [c,d] then
"Text"
else
"Jerky"

-k