creating a formula



I am trying to create a formula that will populate the following excel sheet (See Below)

Denominator divided by numerator equals what % and then the number of numerator hits needed to reach a specific percentage goal.



The spreadsheet was not attached. Edit your qestion to upload it if you want.

But, what do you mean by "number of numerator hits"
don (rep: 1322) Jun 14, '17 at 4:34 pm
Can you tell me how to attach the spreadsheet to this response?
bdennis Jun 14, '17 at 6:01 pm
Add to Discussion



I attempted your task. Question: why is the percentage 75% in one column and .75% in the other?  I'm believing that these are supposed to be the same?

A formula was added to get the final Percentage ~ highlighted in Yellow.  I attempted to correct Percentages to be same formatting.   You could use another column to See if Goal is Reached (use an IF formula).  You could also check into Goal Seeking [ Data Tab, What-if Analysis.



Thank you for your response.
bdennis Jun 16, '17 at 8:25 am
1. Did my example solve your issue?
queue (rep: 348) Jun 16, '17 at 8:48 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login