Creating a formula

[Karsea]

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!

 

[Bill Kuunders]

In G2 enter =IF(E2=0,D2,A2*E2-F2)
in H2 enter =G2-D2

I did have a probelem getting the same numbers as you.
I actually had to change the fee amount to 6.19 to get the same
totals...........
Hope this helped

 

[Karsea]

Hi there,

Yes - sorry I entered the incorrect amount - in spite of this I used your
calculation - and it worked perfectly!

Thank you very much!