How Do I create a formula for the percentage below?
 

I am trying to type a formula to get a percentage for cells B19 and B20 with
the following numbers type in these two cells - B19 - 70 and B20 - 34.5. I
actually have the answer (16.8%) but need to know the formula that would come
up with this number. Any help is appreciated. Thanks

How Do I create a formula for the percentage below?
 

Try this:

=(B20-22.74)/B19

--
Gary''s Student - gsnu200903


"Anita" wrote:

I am trying to type a formula to get a percentage for cells B19 and B20 with
the following numbers type in these two cells - B19 - 70 and B20 - 34.5. I
actually have the answer (16.8%) but need to know the formula that would come
up with this number. Any help is appreciated. Thanks

How Do I create a formula for the percentage below?
 

Gary, Thanks, could you tell me what 22.74 means and how you came up with
that number?

"Anita" wrote:

I am trying to type a formula to get a percentage for cells B19 and B20 with
the following numbers type in these two cells - B19 - 70 and B20 - 34.5. I
actually have the answer (16.8%) but need to know the formula that would come
up with this number. Any help is appreciated. Thanks

How Do I create a formula for the percentage below?
 

It is the discount factor. It is the amount 35.4 must be discounted to
arrive at the correct percentage.

I calculated it using Goal Seek.
--
Gary''s Student - gsnu200903


"Anita" wrote:

Gary, Thanks, could you tell me what 22.74 means and how you came up with
that number?

"Anita" wrote:

I am trying to type a formula to get a percentage for cells B19 and B20 with
the following numbers type in these two cells - B19 - 70 and B20 - 34.5. I
actually have the answer (16.8%) but need to know the formula that would come
up with this number. Any help is appreciated. Thanks

How Do I create a formula for the percentage below?
 

Wow, thanks Gary's student...if I could I'd send you the document I typed so
you can help me with additional formula questions.

"Gary''s Student" wrote:

It is the discount factor. It is the amount 35.4 must be discounted to
arrive at the correct percentage.

I calculated it using Goal Seek.
--
Gary''s Student - gsnu200903


"Anita" wrote:

Gary, Thanks, could you tell me what 22.74 means and how you came up with
that number?

"Anita" wrote:

I am trying to type a formula to get a percentage for cells B19 and B20 with
the following numbers type in these two cells - B19 - 70 and B20 - 34.5. I
actually have the answer (16.8%) but need to know the formula that would come
up with this number. Any help is appreciated. Thanks