Discussions

Expand all | Collapse all

Nested if and statements

  • 1.  Nested if and statements

    Posted 11-13-2017 14:46

    Hi

    I'm trying to create a nested if statement and I'm not sure how to construct it ...

    I want the formula to return the following :

    • If Project Actual equals ?0 then return Project Forecast,
    • If Project Actual AND Project Forecast equal ?0 then return Project Budget,

    • If all 3 equal ?0 then return ?0

    I have tried a few different ways but keep getting errors.

    Thanks

    Sarah



  • 2.  RE: Nested if and statements

    Posted 11-13-2017 14:58
    Quick Base does the IF statements in sequence they are listed and the first one that is "true" wins.

    So you need to do the most specific on first.  for readability its good to list them vertically

    IF(
    [Project Actual] = 0 and [Project Forecast] = 0 and [Project Budget] = 0 ,0,
    [Project Actual] = 0 and [Project Forecast] = 0, [Project Budget],
    [Project Actual] = 0, [Project Forecast])