Calculate a close ratio
[(closed quotes)*100]/(total quotes)
give a number that is the percentage of closed quotes)
"tin95" wrote:
I am working on a template to keep track of every quote that leaves our
office and would like to include a formula to calculate our close ratio based
on the number of accepted proposals. I have a column for Y/N but it could
easily be a check mark or something else. What are some possible formulas?
|