hi
how did you calculate total in G??

regards
FSt1

"Karsea" wrote:

Qty Purchase $ Fee Total Cost Sell $ Fee Total
Gain/Loss

A B C D E F G H
380 5.46 9.95 2068.61 5.63 9.95 2133.21 64.60


My question is if we do not sell (E) and there is no fee (f) how do I create
a calculation to indicate in (G) the amount $ in D (2068.61) and the
gain/loss to show 0 (zero) when there is no sell $ . . . ? THANKS!

Hello,

"F" should read 5.6399 - (sorry . . ) that should now calculate to 2133.21
(minus the 9.95 fee) - what I would really like to achive is that when we do
not sell "H" will not show a -64.60 (nothing was sold at this time so it
should not reflect a loss . . THXS!

"FSt1" wrote:

hi
how did you calculate total in G??

regards
FSt1

"Karsea" wrote:

Qty Purchase $ Fee Total Cost Sell $ Fee Total
Gain/Loss

A B C D E F G H
380 5.46 9.95 2068.61 5.63 9.95 2133.21 64.60


My question is if we do not sell (E) and there is no fee (f) how do I create
a calculation to indicate in (G) the amount $ in D (2068.61) and the
gain/loss to show 0 (zero) when there is no sell $ . . . ? THANKS!