=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
Similar Threads
