Forum Discussion

SarahSarah3's avatar
SarahSarah3
Qrew Member
8 years ago

Nested if and statements

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

  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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])