Forecast using if function

Tim Kuykendall

I am working on a budget tracking sheet where I have a forecast column.  The forecast column is dependent on if there is a value in an estimated cost column or actual cost column. 

If there is no value in the actual cost column, then the forecast column is equal to the value in the estimated cost column.  If value exists in the actual cost column, then the forecast cost is equal to the actual cost.

I'm not sure how to set-up the formula.

 

Andrée Starå

Hi Tim,

Try something like this.

=IF(ISBLANK([Actual Cost $USD]@row); [Estimated Cost $USD]@row; [Actual Cost $USD]@row)

The same version but with the below changes for your and others convenience.

=IF(ISBLANK([Actual Cost $USD]@row), [Estimated Cost $USD]@row, [Actual Cost $USD]@row)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting