Question

Asked on 2011-07-14 at 08:25:28ID: 27197980

Multiple if statements in one formula

by: sarahp500

Rating7.2Very Good

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
Sarah

  1. Problem with decimal in formula
    Have a formula that is referenced in a second fo…
  2. Identify first instance of a condition
    I have a little comparison formula that identifies a …
  3. subreport shows wrong data while within main r…
    My record selection formula in main report is: …
  4. Establishing January 1st in a formula.
    Hello, I'm working on a few financial repor…
  5. Showing latest transaction date of an item based …
    Hello, I have difficulties in returning the l…

Solution

Access this solution immediately by signing up as a member of CrystalReportsExperts.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.

About this Solution

Sign up Now to View This Solution
Zone
general
Tags
Multiple if statements
Participating Experts
2
Solution Grade
B

Replies

 by: peter57r

Posted on 2011-07-14 at 09:31:29ID: 36189362

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by:

Posted on 2011-07-14 at 09:41:01ID: 36189452

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: sarahp

Posted on 2011-07-14 at 09:58:01ID: 36189598

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: sarahp

Posted on 2011-07-14 at 13:46:56ID: 36191285

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: sarahp

Posted on 2011-07-14 at 13:47:26ID: 36191288

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: mlmcc

Posted on 2011-07-14 at 15:24:38ID: 36191849

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Log In

Forgot your password?Sign up

Stay Connected

Top Experts

  1. mlmcc

    334,774

    Wizard

    0 points yesterday

    Profile
  2. James0628

    70,696

    Master

    0 points yesterday

    Profile
  3. LinInDenver

    4,800

    0 points yesterday

    Profile
  4. peter57r

    4,000

    0 points yesterday

    Profile
  5. 13598

    3,520

    0 points yesterday

    Profile
  6. PCIIain

    1,700

    0 points yesterday

    Profile
  7. RickIsWright

    400

    0 points yesterday

    Profile
  8. Dan3D

    300

    0 points yesterday

    Profile

BrowseAre you an Expert?