Multiple IF statements

building reports crystal reports
1

Hi,

I need to create a formula with multiple IF statements like below:
If col1= ‘Yes’ and col2=‘High’ then " " else “good”
If col1= ‘Yes’ and col2=“Low” then " " else “bad”
if If col1= Yes and col2=“low” and date > then " " else “bad”
etc
etc

How can I do this all in one formula. All these conditions are based on 2 fields in the report.

Thanks
Candy

eye_candy :us: (BOB member since 2005-03-18)

2

I have done multiple if’s in a formula checking against multiple fields. FYI: Basic Syntax is easier to work with If’s then Crystal Syntax.

kevlray :us: (BOB member since 2010-06-23)

3

Hi, Kevlray,

Thanks for your reply. Can you post your multiple IF statement formula?

Thanks
Candy

eye_candy :us: (BOB member since 2005-03-18)

4

Hope this will help you

stringVar str := “”;
If col1= “Yes” and col2=“High” then str=“good”
else if col1= “Yes” and col2=“Low” then str=“bad”
str

Cegonsoft OJT

Michael Caine (BOB member since 2011-07-16)