| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM IF
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! |
Threaded Mode
