Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 26th 11, 07:14 PM posted to microsoft.public.excel.newusers
LAS LAS is offline
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2011
Posts: 3
Default Is there a template for this sort of thing?

I want to have a column of figures which will always add up to the same
thing. That is, if I increase one number I want the other numbers to
decrease by a percentage so that the column will still have the same total.
I think there's a technical name for this in budgeting. It seems like it
would be a common thing. Is there a template somewhere?

Also, I'm going to have to drop Outlook Express. I'm shifting my e-mail to
Gmail. Is there a web interface I can use to continue to participate in
this newsgroup?

TIA
LAS



  #2   Report Post  
Old November 26th 11, 08:33 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2011
Posts: 621
Default Is there a template for this sort of thing?

Excel's Solver Add-in will do what you want.

The term you are thinking of might "what if" analysis.

Could you switch to Windows Live Mail?

You can continue with these news groups through WLM news reader.

OR.............................

You can participate in the MS help forums at

http://answers.microsoft.com/en-us

Click on Help in RH top corner to learn how to register and become a
member.


Gord


On Sat, 26 Nov 2011 13:14:56 -0500, "LAS"
wrote:

I want to have a column of figures which will always add up to the same
thing. That is, if I increase one number I want the other numbers to
decrease by a percentage so that the column will still have the same total.
I think there's a technical name for this in budgeting. It seems like it
would be a common thing. Is there a template somewhere?

Also, I'm going to have to drop Outlook Express. I'm shifting my e-mail to
Gmail. Is there a web interface I can use to continue to participate in
this newsgroup?

TIA
LAS

  #3   Report Post  
Old November 27th 11, 11:29 PM posted to microsoft.public.excel.newusers
LAS LAS is offline
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2011
Posts: 3
Default Is there a template for this sort of thing?

Thanks much for all the info.

"Gord Dibben" wrote in message
...
Excel's Solver Add-in will do what you want.

The term you are thinking of might "what if" analysis.

Could you switch to Windows Live Mail?

You can continue with these news groups through WLM news reader.

OR.............................

You can participate in the MS help forums at

http://answers.microsoft.com/en-us

Click on Help in RH top corner to learn how to register and become a
member.


Gord


On Sat, 26 Nov 2011 13:14:56 -0500, "LAS"
wrote:

I want to have a column of figures which will always add up to the same
thing. That is, if I increase one number I want the other numbers to
decrease by a percentage so that the column will still have the same
total.
I think there's a technical name for this in budgeting. It seems like it
would be a common thing. Is there a template somewhere?

Also, I'm going to have to drop Outlook Express. I'm shifting my e-mail
to
Gmail. Is there a web interface I can use to continue to participate in
this newsgroup?

TIA
LAS





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort template Gary Excel Discussion (Misc queries) 2 September 20th 08 06:37 AM
Sort template Gary Excel Discussion (Misc queries) 0 September 20th 08 01:08 AM
Defining Sort Order in Excel Template Yogi Watcher Excel Discussion (Misc queries) 1 November 15th 06 10:09 PM
Lookup sort of thing! Paul Excel Worksheet Functions 2 June 23rd 06 03:41 PM
sort template [email protected] Excel Discussion (Misc queries) 0 January 11th 06 01:07 AM


All times are GMT +1. The time now is 12:00 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017