Clare has attended:
Excel Intermediate course
IF Function
Is there a way to use the IF function to overwrite the data in a cell dependant on whether a number is inputted in another cell?
eg column B is "Actuals" and column C is "forecast". The data in Column C will have been manually inputted already. I need this to remain the same unless a figure is put in the "Actuals" column B. If this happens then the figure in "forecast" column c is overwritten with the "actuals" figure inputted in column B
Many thanks
Clare
RE: IF Function
Hello Clare,
Thank you for your question. Yes, this is possible. The best way is to have a third column which carries the manually entered forecast figures. In the example below, the forecast figures are in column D. The actuals are in column B and the IF functions are in column C.
=IF(B2="",D2,B2)
The IF function will test whether column B holds a value. If not, it will show the forecast figure in column D, otherwise it will show the actual figure in column B. You can hide column D (forecasts) to tidy up the spreadsheet.
I hope this helps!
Kind regards
Marius Barnard
STL