|
SUM IF
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! |
SUM IF
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! |
SUM IF
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" 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! |
SUM IF
hi
based on that the formula in G should be....... =(IF(AND(E3="",F3=""),D3,(E3*A3)-F3)) hope this helps regards FSt1 "Karsea" wrote: 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" 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! |
SUM IF
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! |
SUM IF
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! |
SUM IF
|
SUM IF
|
| All times are GMT +1. The time now is 03:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com