Who's up for a Challenge?

[Growe1]

To the Masters of Excel:

My name is Gary, and I need some help from one of you Masters!

What I'm looking for is help in an 2003 Excel format to show running totals
and percentages. And what I need to do is to show a running total going down
column G and than calculate the percentage in columns H for 2%, I for 4%, and
J for 6% for that total in column G.

I can attach a spreadsheet that I'm working on for your reference if needed.
Just shoot a reply to (e-mail address removed) or to the Discussion Group, and
I'll send it to you. I know that someone out there knows how to do this.
Just please point me in the right direction, I'd be greatly appreciated!

Thanks in advance!

Regards,
Gary

 

[Simon Lloyd]

G is a running total of what? the columns H, I, J are percentages o
what? the running total? or of the first percentage value? for H th
percentage would be =G1/100*4/100 and formast the cell as percent (give
4.00%), is this what you wanted

To the Masters of Excel

My name is Gary, and I need some help from one of you Masters

What I'm looking for is help in an 2003 Excel format to show runnin
total
and percentages. And what I need to do is to show a running total goin
dow
column G and than calculate the percentage in columns H for 2%, I fo
4%, an
J for 6% for that total in column G

I can attach a spreadsheet that I'm working on for your reference i
needed
Just shoot a reply to (e-mail address removed) or to the Discussion Group
an
I'll send it to you. I know that someone out there knows how to d
this
Just please point me in the right direction, I'd be greatl
appreciated

Thanks in advance

Regards
Gar

-
See you at the Top

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[Growe1]

Thanks Simon,

And I'm sorry that I did not give you more info about what I needed to do.
Here's a better example: Below is my Amount Received, and then my running
Total in column G. Then comes the percentages of 2% in H, 4% in I, and 6% in
J, which looks like this on the spreadsheet.

Amount Received Total 2% 4% 6%
$26,277,077 $26,277,077 $525,542 $1,051,083 $1,576,625
$6,192,000 $32,469,077 $649,382 $1,298,763
$600,000 $33,069,077 $661,382
$498,028 $34,167,105


Please advise... And if you like, I can send you the spreadsheet?

Thanks,
Gary

 

[Simon Lloyd]

Growe1, why not join our (link below) for free!, when making a post yo
can attach a workbook before submitting, if you do join and make a pos
regarding this please try to post in this thread (link below) so tha
people who have been helping or following can still continue to do so

Thanks Simon

And I'm sorry that I did not give you more info about what I needed t
do
Here's a better example: Below is my Amount Received, and then m
runnin
Total in column G. Then comes the percentages of 2% in H, 4% in I, an
6% i
J, which looks like this on the spreadsheet

Amount Received Total 2% 4% 6
$26,277,077 $26,277,077 $525,542 $1,051,083 $1,576,62
$6,192,000 $32,469,077 $649,382 $1,298,76
$600,000 $33,069,077 $661,38
$498,028 $34,167,10


Please advise... And if you like, I can send you the spreadsheet

Thanks
Gar





Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1
(http://www.thecodecage.com/forumz/showthread.php?t=75381

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[Growe1]

Growe1, why not join our (link below) for free!, when making a post yo
can attach a workbook before submitting, if you do join and make a pos
regarding this please try to post in this thread (link below) so tha
people who have been helping or following can still continue to do so!

Thanks Simon, and I followed your advice to join your forum.

Attached is the excel file I was referring too. Please see if you ca
help me solve this formula.

Best Regards,
Gary Row

+-------------------------------------------------------------------
|Filename: Working_Copy_-__Excel_Payment_Schedule__2009.xls
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=99
+-------------------------------------------------------------------