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, ...
Forum Discussion
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])
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])