Judy -

The formula =A3*1%*(1-10*B2) generally would mean to take the value in cell
B2, multiply it by 10, subtract the result from 1, multiply that result by
1%, and finally multiply that result by the value in cell A3.

But, if that formula is in cell B2, it would cause a circular reference, and
Excel usually would display an error message.

Maybe you should (a) ask the originator what was intended or (b) describe
what you would like to do and start over.

- Mike Middleton
http://www.MikeMiddleton.com



"Judy" wrote in message
...
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.