Can any of you EXCEL guru's help me out with couple of spreadsheet formulas
? (hopefully you can view att'd)

I'm trying to automate a sheet to track my stock option trades. I've
figured out how to have my profit/loss field come up with an accurate number
but it always shows a negative $20 for commissions even in the lines which I
do not show a trade, which messes up my sheet totals. So my questions
a

1. How do I do a "IF" formula with the result being zero or blank if no
entry is made but also calculate the profit or loss when the trade is
entered? Currently I'm using (E5*100)*I5-(E5*100)*F5-20

2. How do I calculate a "number of days held" if date in = 08/19/03 & date
out = 09/13/03

3. What would the formula be to calculate annual % return from the
profit/loss column and the number of days held column ?

4. What would the formula be to calculate the immediate % return (not
annualized)

Again, I would like all the resulting fields to be blank or show zero,
unless trades are actually entered.

Thanks for all / any input.
Joe