percent?

[Al Long]

You folks have been VERY helpful to me with these forumlas, now I have another.

I have 3 columns with number of forms processed, # of forms that were complete and # of forms that were incomplete. What I want to show in a seperate column is the % of incomplete forms from the total processed.

BIG thanks in advance

 

[plettieri]

Hi:

You could try something like this...

Account-receivable-ageing.xls
	J	K	L	M	N
25				%
26	processed	completed	incompleted	incompl
27
28	1200	330	870	73%
29	2255	333	1922	85%
30	22	3	19	86%
31	111	33	78	70%
32
33	3588	699	2889	81%
34
35
Sheet3

hope this helps
plettieri

 

[jcvoth]

Assuming you are using column A, B, and C and you want the # of C out of B+C, I would put :

=c/b

now, if you want a total percentage, you'd have to do something like

=sum(c:c)/sum(a:a)

 

[jcvoth]

plettieri is right on.

and correction on my earlier comment. c/b should be c/a.

 

[Al Long]

Thank you very much, I was just unsure of the formula....