LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Show forecast accuracy of customer schedules as a percentage

A customer forecasts that they will take 20 units next month. At the end of
the month it turns out that they only took 15 units. How accurate was their
forecast? Can this be displayed as a percentage? The values change every
month and there are many different items to analyse.

Also vice versa, 15 units forecast and 20 units taken.

Version 10.0.2614
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
show customer based on Weekday Jill Excel Worksheet Functions 3 April 5th 06 04:07 PM
How to show negative percentage? brett Excel Worksheet Functions 3 January 9th 06 06:06 AM
Show both value and percentage on Waterfall Chart Tim Charts and Charting in Excel 2 September 29th 05 04:57 PM
show in a excel graphic a total percentage for 5 diff data fiels Julio Charts and Charting in Excel 1 September 1st 05 01:26 PM
How can I conditional format to show either a percentage or a whol Simon Excel Discussion (Misc queries) 1 January 25th 05 10:29 AM


All times are GMT +1. The time now is 02:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"