Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
xela1986
 
Posts: n/a
Default best and worst outcomes

i have been attempting to forecast a balance sheet & P&L account for the
following year which i have managed to do, but am unable to work out the best
and worse possible outcomes and was wondering if anyone knew how to do this?

thanks
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BruceP
 
Posts: n/a
Default best and worst outcomes


If you know the values you want to use for best and worst cases, you
could use Scenario Manager (Tools Scenarios). I'd like to suggest
that you first create a "Normal" scenario, that keeps your current
values. That way, if you accidentaly close the sheet in the middle of
one of your other scenarios, you can still retrieve your initial
values.


--
BruceP
------------------------------------------------------------------------
BruceP's Profile: http://www.excelforum.com/member.php...o&userid=33653
View this thread: http://www.excelforum.com/showthread...hreadid=535721

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



All times are GMT +1. The time now is 07:59 PM.

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

About Us

"It's about Microsoft Excel"