percent formula

claireworks · Feb 25th, 2002, 05:19 AM

Hello, I'm new to Excel and am creating a personal database of my music CDs. There are two price columns, E1 and F1. E1 is the price of the CD when bought 'used', while F1 is the 'new' price. I'd like to calculate how much (in terms of percent) I save when buying the used version. That is, what formula do I use to find out what percent of F1 is E1? Thank you very much in advance!

Aladin Akyurek · Feb 25th, 2002, 05:38 AM

Quote:

On 2002-02-25 04:19, claireworks wrote:
Hello, I'm new to Excel and am creating a personal database of my music CDs. There are two price columns, E1 and F1. E1 is the price of the CD when bought 'used', while F1 is the 'new' price. I'd like to calculate how much (in terms of percent) I save when buying the used version. That is, what formula do I use to find out what percent of F1 is E1? Thank you very much in advance!

In G1 enter: =IF(F1,E1/F1,0)

GeorgeAdamson · Feb 25th, 2002, 05:38 AM

Try entering this formula into the cell where you want the result:

=100-G3/H3 %

That should give you the difference as a percentage

Chris Davison · Feb 25th, 2002, 05:40 AM

the %age of F1 of E1 is simply E1/F1 formatted as a percentage

Bought £10
Now £ 14

is 71%

Savings in terms of the new price will just be 1-this %age result : 29%

or =1-(e1/f1), again, formatted to a %age

_________________
Hope this helps,
Chris

[ This Message was edited by: Chris Davison on 2002-02-25 05:40 ]

claireworks · Feb 25th, 2002, 07:49 AM

Wow, this messageboard is simply great! I learned a lot just by reading other people's posts, and now that I decided to ask a question, I got all the answers I need, in less than 24 hours. Thanks so much!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 25th, 2002, 05:19 AM	#1
claireworks New Member Join Date: Feb 2002 Location: Nagoya, Japan Posts: 2	Hello, I'm new to Excel and am creating a personal database of my music CDs. There are two price columns, E1 and F1. E1 is the price of the CD when bought 'used', while F1 is the 'new' price. I'd like to calculate how much (in terms of percent) I save when buying the used version. That is, what formula do I use to find out what percent of F1 is E1? Thank you very much in advance!

Feb 25th, 2002, 05:38 AM	#3
GeorgeAdamson New Member Join Date: Feb 2002 Posts: 14	Try entering this formula into the cell where you want the result: =100-G3/H3 % That should give you the difference as a percentage

Feb 25th, 2002, 05:40 AM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	the %age of F1 of E1 is simply E1/F1 formatted as a percentage Bought £10 Now £ 14 is 71% Savings in terms of the new price will just be 1-this %age result : 29% or =1-(e1/f1), again, formatted to a %age _________________ Hope this helps, Chris [ This Message was edited by: Chris Davison on 2002-02-25 05:40 ]

Feb 25th, 2002, 07:49 AM	#5
claireworks New Member Join Date: Feb 2002 Location: Nagoya, Japan Posts: 2	Wow, this messageboard is simply great! I learned a lot just by reading other people's posts, and now that I decided to ask a question, I got all the answers I need, in less than 24 hours. Thanks so much!!!