PDA

View Full Version : [SOLVED:] VBA Code or Forumula



pyasanewa
04-13-2013, 08:41 AM
I need a VBA code or simple formula that automatically updates YOY automatically once we fill Actual columm (#5). Could someone please help me? I am showing first cell of YOY on Actual number and second YOY based on 3rd Forecast. I wanted to update second YOY update automatically once I enter actual (where X is marked).

GarysStudent
04-13-2013, 09:53 AM
What is YOY?

mdmackillop
04-13-2013, 02:47 PM
=IF(F3="",E3/B3*10,F3/B3*10)

pyasanewa
04-13-2013, 04:27 PM
What is YOY?

Thanks Gary. YOY is Year over Year from 2012 to 2013.