How Do I create a formula for the percentage below?

A

Anita

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
 
A

Anita

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

Gary''s Student

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.
 
A

Anita

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL 2003*FORMULA TO HILIGHT SPECIFIC CELLS WITH TRUE RESULTS? 6
Doughnut Chart linked with the slicer in the pivot table 0
Formula for percentage calculation 1
help with the syntax for using range name in a formula? 2
how to get the percentage symbol with the result? 3
Macro for displaying formula 3
Challenging the GOAL SEEK function within a bonus scheme 6
Formula Cell color limitation 7

Top