Forecast vs Actuals variance based on Actuals input

[MO11STA]

Hi All

Hope you are all well and able to help

Apologies if this question has been answered as I was unable to find a similar question

Please can someone advise if it's possible to enter a formula which calculates the variance between forecast and actuals only when actuals are inputted by the user, as we expect the user to forecast out over the year but this formula won't work as it takes all forecasted against actuals which will always be a incorrect variance

Thanks for your help in advance

 

[awoohaw]

what version of excel are you using?

 

[MO11STA]

what version of excel are you using?

O365

 

[Fluff]

O365

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[MO11STA]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Apologies, I have updated this now