LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
krasavchik
 
Posts: n/a
Default simple average formula...can you solve it in principle?

How do you run a report or formula for the following principle example?

Based on a sales competition, I have 100 days to get my daily average income
to a total average of $45. I am averaging $30 income daily through the first
61 days. How do I run a report that can tell me (instead of manually doing
it) the amount of daily income I need to average for the remaining 38 days in
order to meet my goal of $45.00 for the 100-day period? I am using 2003
version.

thanks....

A.W.
 
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
moving the formula "average" over one column in a macro drumstu Excel Worksheet Functions 1 August 23rd 05 08:01 PM
Formula to average certain times Denise Excel Discussion (Misc queries) 5 July 18th 05 01:02 PM
Formula to Average times...again Denise Excel Discussion (Misc queries) 1 July 15th 05 08:26 PM
Average Formula with Criteria PW11111 Excel Discussion (Misc queries) 1 June 10th 05 02:22 PM
Simple formula doesn't quite add up circeo Excel Discussion (Misc queries) 3 January 17th 05 09:04 PM


All times are GMT +1. The time now is 06:07 AM.

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"