inked
07-09-2006, 10:31 PM
I need to calculate a number based on two criteria. For example: revenue at 2:00 am last Sunday and revenue at 2:00 am the Sunday before. Based on those two criteria, what will the predicted revenue be this Sunday at 2:00 am. Should I simply add the two together and divide by two, or should I introduce a TREND and/or FORECAST function?
D32 = 2:00 am; E32 = revenue Sunday two weeks ago; H32 = revenue last Sunday.
Thanks.
ep
D32 = 2:00 am; E32 = revenue Sunday two weeks ago; H32 = revenue last Sunday.
Thanks.
ep