LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 53
Default two-variable data table question

I have inherited the spreadsheet below containing a two-variable data table.
Can someone tell me what the 1-10 portion of the formula means; I can't find
what it is relating to.

The formula in cell B2 is: =A3*1%*(1-10*B2)

A B C D E
F G
1 Expense vs. Sales
2 0 1% 2% 4% 6% 8%
3 Sales $1,000,000 9000 8000 6000 4000 2000
4 $2,000,000 18000 16000 12000 8000 4000
5 $3,000,000 27000 24000 18000 12000 6000
6 $4,000,000 36000 32000 24000 16000 8000
7 $5,000,000 45000 40000 30000 20000 10000

Thanks for the help.

 
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
Lookup data in a variable table & retrieve data from a pivot table Shawna Excel Worksheet Functions 3 October 10th 08 11:11 PM
Get Formula from 2 variable Data Table Chad Excel Discussion (Misc queries) 3 June 27th 08 11:51 PM
one variable data table alexasanford Excel Worksheet Functions 2 March 8th 07 06:57 AM
How do I create a one variable data table? Prelll91 Excel Discussion (Misc queries) 1 February 27th 05 07:48 PM
How do I create a one variable data table? prelll91 Excel Discussion (Misc queries) 0 February 27th 05 07:47 PM


All times are GMT +1. The time now is 02:57 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"