# Re: Percentage equation trouble

Guest
Posts: n/a

 25th Mar 2006
=D2/F2 *100
put that in the result cell.
F2 would be 96.8% of D2
or
write a macro
This is assuming the two numbers are side by side. and there are no
blanks.
Results will end up in the column to the right of the second column.
This will do all rows until there are blanks.
Select D2 with your mouse and then run.

dim a,b as integer
dim c as double
do while isempty(activecell.value)=false
a=activecell.value
b=activecell.offset(0,1).value
c=(a/b)*100
activecell.offset(0,2).value=c
activecell.offset(1,0).select
loop

smit7977 wrote:
> How do I get the percentage of a series of numbers?
>
> I've tried several equations and I guess my math skills are pretty
> rusty. Can anyone help me?
>
> Example Cell D2 holds the number 93000.00 and Cell F2 holds 96000.00
> Continuing down these columns the numbers will vary but I need to find
> a way to find the differing percentages of one number compared to the
> other?
>
> Does this make sense?
>
> HELP!
>
>
> --
> smit7977
> Posted from - http://www.officehelp.in

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post kpahel@adelphia.net Microsoft Excel Discussion 0 25th Mar 2006 02:37 AM Harlan Grove Microsoft Excel Discussion 0 24th Mar 2006 10:10 PM =?Utf-8?B?QWJvdXQgdG8gaGF2ZSBubyBtb3JlIEhhaXIhISEh Microsoft Word Document Management 2 20th Mar 2006 06:28 PM =?Utf-8?B?R2FieSBMLg==?= Microsoft Excel Misc 0 27th Sep 2005 09:24 PM =?Utf-8?B?Um9k?= Microsoft Excel Worksheet Functions 3 23rd Oct 2003 03:37 PM

Features