percent formula

[claireworks]

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]

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]

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]

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]

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!!!