TVCH FORUMS HOME . JOIN . FAN CLUBS . ABOUT US . CONTACT . CHAT  
Bomis   Quick Links   TOPICS . TREE-VIEW . SEARCH . HELP! . NEWS . PROFILE
Excel Spreadsheet Help Needed

The TVClubHouse: General Discussions ARCHIVES: 2004 Nov. - 2005 Jan.: All Things Technical: The Help Desk (ARCHIVES): Excel Spreadsheet Help Needed users admin

Author Message
Luvmyjrt
Member

09-18-2003

Sunday, October 24, 2004 - 10:48 am   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
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
1250,000250,000
2175,000300,000
3
-30%
20%


Hope this helps.

Luvmyjrt
Member

09-18-2003

Sunday, October 24, 2004 - 3:10 pm   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
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   Edit Post Move Post Delete Post View Post    
Worked great, thanks!

(See that's why I don't buy an "Excel for Dummies", you guys are the best!