Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|