HI

I need to work out the projected future profit margin based on the
trend of the previous period of days in the month.

For instance

Day 1 - 25.60%
Day 2 - 24.50%
Day 3 - 26.90%
Day 4 - 23.20%
Day 5 - 21.00%

What would be the trend for the rest of the month based on the above.
Please advise the best function/formule to calculate this.

Thanks

VC


--
uplink600
------------------------------------------------------------------------
uplink600's Profile: http://www.excelforum.com/member.php...fo&userid=9408
View this thread: http://www.excelforum.com/showthread...hreadid=522104