Thanks:  0
Likes:  0

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

2. 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)

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

=100-G3/H3 %

That should give you the difference as a percentage

4. 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 ]

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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•