Hi again,

Is there a way I can post the actual spreadsheet - so that you can get a
better idea of my explaination? The only way to explain the issue is to see
it . . .

"FSt1" wrote:

hi
not sure what you mean by red....but if you are getting a negative number
somewhere that you think you shouldn't be, you may be a victim of roundoff.
check your decimal places.

regards
FSt1

"Karsea" wrote:

Hi there,

I posted my reply for the calculation for 'G" (previous posting) I plugged
in the formula that was suggested . . it works but it is still shows in the
"red" - so therefor it is actually debiting the account. If it was not sold
(exception at a loss), it should still be an asset to the fund.

Thank you again!

"FSt1" wrote:

hi
you didn't tell me how you calculated 2133.21 in G. so i am still at a loss
because i can't complete the formula untill i know that. but here is what i
have
in G.....
=(IF(AND(E3="",F3=""),D3, your formula))
the "your formula" is what i don't know. if E and F are blank the the
formula will draw what is in D otherwise it will do your caculation (which i
don't know)
then in H...
=IF(G3=0,0,G3-D3)
or if G is 0 then 0(no gain/loss) otherwise G-D

plug your calculation into the above and see if it works for you. if not
post back with the formula you use to get 2133.21.

regards
FSt1



"Karsea" wrote:

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!