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.