Nested if and statements

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered

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

Photo of Sarah

Sarah

  • 20 Points

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
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])
(Edited)