I am wanting to calculate forecast accuracy compared to sales where I
have one column with actual sales figures and two other columns with
forecasts. What I need to do is display the accuracy of each forecast
against actual sales in terms of a percentage.

Simply showing the percentage difference is not good enough (can be
anywhere from -200% to +200% as our sales guys are rubbish at
forecasting), I need to show the accuracy as a figure from 0% to 100%.

I've been mucking around with this for over three hours and not getting
anywhere.

Can anyone provide some assistance?


--
AussieExcelUser
------------------------------------------------------------------------
AussieExcelUser's Profile: http://www.excelforum.com/member.php...o&userid=32326
View this thread: http://www.excelforum.com/showthread...hreadid=549249