Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 90
Default Scenarios

My financial statement documents consist of several worksheets. Many of the
cells in most of the worksheets are linked to each other. The revenue is
determined by the number of units sold X the price of the unit. I have five
different units that are all sold at different rates. I want to set up
scenarios in a table that will show what the revenue and net income would be
if I increased each unit by 5%. I do not want it to change my financial
statements; just a table that would show what those numbers would do if we
were to change the rate. Is this possible?

Deb
 
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
IF scenarios rdwngr23 Excel Worksheet Functions 1 April 8th 08 08:38 PM
Scenarios Petros[_2_] Excel Discussion (Misc queries) 0 March 28th 07 04:06 PM
Scenarios David Excel Discussion (Misc queries) 2 February 20th 07 01:11 AM
scenarios arutchelvi Excel Discussion (Misc queries) 2 February 1st 07 12:54 PM
Scenarios JosefS Excel Worksheet Functions 2 June 23rd 05 09:23 PM


All times are GMT +1. The time now is 01:13 PM.

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

About Us

"It's about Microsoft Excel"