Skip to main content
Question

Nested if and statements

  • November 13, 2017
  • 0 replies
  • 43 views

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

      This topic has been closed for replies.

      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])
        Terms & ConditionsAccessibility statement