If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need help with a formula
I am trying to get Excel to make some calculations for me. This is my first
time trying to use Excel and I can't seem to figure out how to tell it what I want it to do. I want it to tell me a percentage rate. I tell it how much I paid for an item and how much I sold the item for. I got the formula to get it to give me the amount of the difference, but how would I tell it to give me that number in the next cell as the % as well? I hope that makes since. For instance, if I bought a car for 500.00, turned around and sold it for 750.00, I've already got it to give me the difference amount (250.00), now how would I get it to tell me what that 250.00 equals as a percent? Thanks |
#2
|
|||
|
|||
Cell A1: 750
Cell B1: 500 Cell C1: =A1-B1 Cell D1: =C1/A1 "Buckwheat" wrote in message ... I am trying to get Excel to make some calculations for me. This is my first time trying to use Excel and I can't seem to figure out how to tell it what I want it to do. I want it to tell me a percentage rate. I tell it how much I paid for an item and how much I sold the item for. I got the formula to get it to give me the amount of the difference, but how would I tell it to give me that number in the next cell as the % as well? I hope that makes since. For instance, if I bought a car for 500.00, turned around and sold it for 750.00, I've already got it to give me the difference amount (250.00), now how would I get it to tell me what that 250.00 equals as a percent? Thanks |
#3
|
|||
|
|||
Eggman, thanks for your help...It made perfect since when I saw your answer.
I just finished an excel class and now that the boss wants me to do a project, I've mentally frozen...first time that's really happened to me. Thanks for your help "Buckwheat" wrote: I am trying to get Excel to make some calculations for me. This is my first time trying to use Excel and I can't seem to figure out how to tell it what I want it to do. I want it to tell me a percentage rate. I tell it how much I paid for an item and how much I sold the item for. I got the formula to get it to give me the amount of the difference, but how would I tell it to give me that number in the next cell as the % as well? I hope that makes since. For instance, if I bought a car for 500.00, turned around and sold it for 750.00, I've already got it to give me the difference amount (250.00), now how would I get it to tell me what that 250.00 equals as a percent? Thanks |
#4
|
|||
|
|||
Always glad to help... Good Luck
"Buckwheat" wrote in message ... Eggman, thanks for your help...It made perfect since when I saw your answer. I just finished an excel class and now that the boss wants me to do a project, I've mentally frozen...first time that's really happened to me. Thanks for your help "Buckwheat" wrote: I am trying to get Excel to make some calculations for me. This is my first time trying to use Excel and I can't seem to figure out how to tell it what I want it to do. I want it to tell me a percentage rate. I tell it how much I paid for an item and how much I sold the item for. I got the formula to get it to give me the amount of the difference, but how would I tell it to give me that number in the next cell as the % as well? I hope that makes since. For instance, if I bought a car for 500.00, turned around and sold it for 750.00, I've already got it to give me the difference amount (250.00), now how would I get it to tell me what that 250.00 equals as a percent? Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula to Count and Return Most common Value in a Dynamic Named Range | Tinä | General Discussion | 1 | October 23rd, 2004 11:26 PM |
Formula to Count and Return Most common Value in a Dynamic Named Range | Tinä | General Discussion | 1 | October 23rd, 2004 08:51 PM |
Excel Formula | yuki | Worksheet Functions | 7 | September 28th, 2004 02:40 AM |
Add to formula | Pat | Worksheet Functions | 16 | September 24th, 2004 03:38 PM |
Alternative formula to HLookup | Bernie Deitrick | Worksheet Functions | 0 | March 26th, 2004 12:53 PM |