| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How To Create a Percentage Discount in Invoice | Excel Discussion (Misc queries) | |||
| How can I create a percentage increase formula? | Excel Worksheet Functions | |||
| How do I create a formula by percentage within a formula? | Excel Worksheet Functions | |||
| Create semi-log plot for percentage | Charts and Charting in Excel | |||
| How do I create a formula to calculate the average percentage rat | Excel Worksheet Functions | |||
Hybrid Mode
