View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karsea Karsea is offline
external usenet poster
 
Posts: 16
Default 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!