It's not 1 minus 10, it's 1 - 10*B2
(Remember that multiplication has precedence over subtraction in the
precedence of arithmetic operators).

If you don't understand where the 10 comes from, how many percent do you
reduce A3*1% by for every 1% change in row 2?
--
David Biddulph

Judy wrote:
I figured the 1-10 meant 1 minus 10, but I don't know where that's
coming from. I don't see 10 of anything in the spreadsheet, so what
is the 1 minus 10 relating to?

"Rasoul Khoshravan" wrote:

one minus 10 multiplied by B2

On Feb 7, 7:36 am, Judy wrote:
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.