A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Need help with a formula



 
 
Thread Tools Display Modes
  #1  
Old April 6th, 2005, 05:19 AM
Buckwheat
external usenet poster
 
Posts: n/a
Default 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  
Old April 6th, 2005, 05:30 AM
eggman
external usenet poster
 
Posts: n/a
Default

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  
Old April 6th, 2005, 06:05 AM
Buckwheat
external usenet poster
 
Posts: n/a
Default

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  
Old April 6th, 2005, 05:06 PM
eggman
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 09:15 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.