Take a look at the TREND function. equally, you could do a line plot and add
the trend line plus display the equation of that line (of form y=Mx+c).

HTH

"uplink600" wrote:


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