Jensen 3:16
Board Regular
- Joined
- Jul 4, 2004
- Messages
- 50
In my excel spreadsheet I have the following information:
Stock Price $40(C7)
$4.00(C8) Max Loss
$6.00(C9) Max Gain
$34.00(C10)Lower Break-even
$46.00(C11)Upper Break-even
What I am trying to do is (1) generate a formula which shows the percentage difference from $40 which is in cell C7 to the lower break-even point of $34 in cell c10
and
(2)the percentage difference from $40 which is in cell C7 to the upper break-even point of $46 in cell c11
Any suggestions how to construct these formulas? Any help would be greatly appreciated. Thank You.
Stock Price $40(C7)
$4.00(C8) Max Loss
$6.00(C9) Max Gain
$34.00(C10)Lower Break-even
$46.00(C11)Upper Break-even
What I am trying to do is (1) generate a formula which shows the percentage difference from $40 which is in cell C7 to the lower break-even point of $34 in cell c10
and
(2)the percentage difference from $40 which is in cell C7 to the upper break-even point of $46 in cell c11
Any suggestions how to construct these formulas? Any help would be greatly appreciated. Thank You.