Author |
Message |
Luvmyjrt
Member
09-18-2003
| Sunday, October 24, 2004 - 10:48 am
Can anyone point me to a good website where I can find Excel formulas? I have a spread sheet somewhat like this: A: 250,000 A: 250,000 B: 175,000 B: 300,000 C: = +/- % C: +/- % I want to be able to show positive or negative growth in the total of the A and B Cells. Does this make any sense at all???
|
Draheid
Moderator
09-09-2001
| Sunday, October 24, 2004 - 12:09 pm
Luvmyjrt: Is this what you're seeking?
| A | B | 1 | 250,000 | 250,000 | 2 | 175,000 | 300,000 | 3 | =(A2-A1)/A1 | =(B2-B1)/B1) | Format A3 & B3 as Percentile and you should see this:
| A | B | 1 | 250,000 | 250,000 | 2 | 175,000 | 300,000 | 3 | -30% | 20% | Hope this helps.
|
Luvmyjrt
Member
09-18-2003
| Sunday, October 24, 2004 - 3:10 pm
It is Dra....do you know of a handy site to find that type of stuff? Thanks!
|
Draheid
Moderator
09-09-2001
| Sunday, October 24, 2004 - 5:11 pm
I'm not familiar with any particularly good site to recommend. This was from personal knowledge. I rarely look for help unless it's for something really out of the ordinary such as the formula for converting unixtime to standard date/time. I would suggest you try using Google and enter a search subject such as +Excel +tips and see what turns up. Hope this helps.
|
Landi
Member
07-29-2002
| Sunday, October 24, 2004 - 7:14 pm
i would recommend "excel for dummies" all of the "dummies" books are so helpful, and are put in an easy to read format.
|
Luvmyjrt
Member
09-18-2003
| Saturday, January 08, 2005 - 12:25 pm
Okay, I'm back and need another formula: I have c = sales d = goal e = % to goal f = pipeline I need to add sales + pipeline and divide by goal to arrive at a percentage to goal. What does that formula look like? HELP!
|
Jimmer
Member
08-30-2000
| Saturday, January 08, 2005 - 12:56 pm
Assuming cells c1 = sales d1 = goal e1 = % to goal f1 = pipeline The formula would be =(c1+f1)/d1*100 But test it out to see if it makes sense.
|
Luvmyjrt
Member
09-18-2003
| Sunday, January 09, 2005 - 9:17 am
Worked great, thanks! (See that's why I don't buy an "Excel for Dummies", you guys are the best!
|