Userque, can you help me with a simple excel formula? How do I put an "if formula on my worksheet (column G) without putting 1 on either Buy and Sell columns?
See, if I multiply Buy (D) column with shareprice (F) , I get a zero because sell (E) column is blank. So I end up putting a (1).
The same goes with sell (E) column *shareprice (F), because Buy (D) column is blank.
I drag down the formula on G column.
|
|
|
|
|
|
|
Gain/Loss |
|
|
|
Buy |
Sell |
|
|
$240.22 |
6-Jun |
SPXU |
|
18 |
1 |
26.45 |
$ 476.10 |
|
7-Jun |
SPXU |
|
1 |
18 |
26.12 |
$ 470.16 |
($5.94) |
|
|
|
|
|
|
|
|