SUM IF

[Karsea]

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!

 

[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!

 

[Karsea]

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!

 

[Karsea]

Hi again,

"E" should read 5.6399 times (X) 380 "A"
minus (-) 9.95 "F" that arrives at the calculation "G" 2133.21

Thanks again!

 

[FSt1]

hi
based on that the formula in G should be.......
=(IF(AND(E3="",F3=""),D3,(E3*A3)-F3))

hope this helps
regards
FSt1

 

[FSt1]

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]

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]

hi
(e-mail address removed)

regards
FSt1

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]

hi
it's late here in atlanta and am about to crash.. i may not look at untill
tomorrow.

regards
FSt1