Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shadowshady
 
Posts: n/a
Default Calculating a percentage with the end percentage in mind

I need to create a formula that will calculate percentage needed to reach a
determined percentage at the end of the month.

For example,
week 1 = 14%
Week 2 = 13.2%
Week 3 = ?
Week 4 = ?

Month End Goal 13.8%

Is there a way to calculate what percentage is needed for week 3 and 4 to
acheive the goal?

Thanks, Noah
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mallycat
 
Posts: n/a
Default Calculating a percentage with the end percentage in mind


It is best to do this type of thing using the original numbers, not the
percentages. Work out the balance needed to make the total for the
month then divide it by the number of weeks left, and calculate the %
from there.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=552882

  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Calculating a percentage with the end percentage in mind

If you put in

=3*13.8%-SUM(A1:A2)

in the third cell, and

=4*13.8%-SUM(A1:A3)

in the fourth cell, that should doi it. At first the 4th cell will show
13.8%, as the third will make all the correction, but when you overtype that
with the achieved value, the fourth will adjust.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Shadowshady" wrote in message
...
I need to create a formula that will calculate percentage needed to reach

a
determined percentage at the end of the month.

For example,
week 1 = 14%
Week 2 = 13.2%
Week 3 = ?
Week 4 = ?

Month End Goal 13.8%

Is there a way to calculate what percentage is needed for week 3 and 4 to
acheive the goal?

Thanks, Noah



Reply
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
Calculating a Percentage Reegan Excel Worksheet Functions 2 November 9th 06 01:04 PM
Calculating forecast accuracy as a percentage AussieExcelUser Excel Discussion (Misc queries) 2 June 7th 06 06:19 AM
Calculating Percentage Rent Paul S Excel Worksheet Functions 4 February 24th 06 08:31 PM
Calculating Percentage mconnolly Excel Worksheet Functions 1 August 29th 05 09:48 PM
calculating 10 percentage of items in a column ysymon Excel Discussion (Misc queries) 2 August 24th 05 04:16 PM


All times are GMT +1. The time now is 03:32 PM.

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

About Us

"It's about Microsoft Excel"