Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a formula
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a formula
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 -- Greetings from New Zealand "Karsea" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a formula
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! "Bill Kuunders" wrote: 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 -- Greetings from New Zealand "Karsea" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula creating itself | Excel Discussion (Misc queries) | |||
need help creating formula | Excel Worksheet Functions | |||
I need help creating a formula | Excel Discussion (Misc queries) | |||
Help with creating Formula again | Excel Worksheet Functions | |||
Creating a formula | New Users to Excel |