Good afternoon, I am needing help putting together a formula to make a chart as follows:
Trying to find an easier way to fill the rest of this chart. A sample of the formula I was using is : =(D7*C8)*100 but I have to do it to each individual cell. Is there an easier way?
Trying to find an easier way to fill the rest of this chart. A sample of the formula I was using is : =(D7*C8)*100 but I have to do it to each individual cell. Is there an easier way?
# of Contracts | ||||||||||||
1 | 5 | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 | 50 | ||
$1.00 | $100.00 | $500.00 | ||||||||||
$1.25 | $125.00 | $625.00 | ||||||||||
$1.75 | $175.00 | $875.00 | ||||||||||
STRIKER PRICE: | $2.00 | $200.00 | $1,000.00 | |||||||||
$2.25 | $225.00 | $1,125.00 | ||||||||||
$2.50 | $250.00 | $1,250.00 | ||||||||||
$2.75 | $275.00 | $1,375.00 | ||||||||||
$3.00 | $300.00 | $1,500.00 | ||||||||||
$3.25 | $325.00 | $1,625.00 | ||||||||||
$3.50 | $350.00 | $1,750.00 | ||||||||||
$3.75 | $375.00 | $1,875.00 | ||||||||||
$4.00 | $400.00 | $2,000.00 | ||||||||||
$4.25 | $425.00 | $2,125.00 | ||||||||||
$4.50 | $450.00 | $2,250.00 | ||||||||||
$4.75 | $475.00 | $2,375.00 | ||||||||||
$5.00 | $500.00 | $2,500.00 | ||||||||||
$5.25 | $525.00 | $2,625.00 | ||||||||||
$5.50 | $550.00 | $2,750.00 | ||||||||||
$5.75 | $575.00 | $2,875.00 | ||||||||||
$6.00 | $600.00 | $3,000.00 |