creating a formula

0

Hello,

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.

Answer
Discuss

Discussion

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

Answers

0

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.

Discuss

Discussion

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