Thread: Scenarios
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Debbie Debbie is offline
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