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: 12
Default Creating a formula calculates time impact on achieveing sales quota

Hi,

Please I need a help on the following!

I am a salesman (for instance) and I have a target of 1,000 USD to be
achieved on Jan. 15th with a weight of 30% - I did achieve the target
but on Feb. 1st.

How can I use excel to calculate (consider) the delay in time even if
the target achieved? I believe the weighted score will be affected!

Thanks in advance.

Khaledity

 
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
Impact of negative sales on inventory weeks on hand DHallgren Excel Discussion (Misc queries) 4 February 15th 07 02:57 PM
Creating a formula that calculates a total cell Growers Excel Discussion (Misc queries) 4 August 1st 06 09:47 PM
Need a function that calculates time between 2 dates RawisTheGameHhH Excel Worksheet Functions 8 July 1st 06 01:54 AM
Why doesn't the finance rate in MIRR impact the formula result? opieandy Excel Worksheet Functions 0 June 27th 05 09:01 PM
Is there a time sheet template that calculates hours? CTG Excel Discussion (Misc queries) 2 February 16th 05 09:27 AM


All times are GMT +1. The time now is 10:08 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"