"wrosie" wrote:
(If I were doing this in Crystal Reports, I'd use
If...Then...Else. I had no idea how to do "else" in Excel.)

Oh, come on! Anyone experienced with if-then-else
statements in any language should recognize "value_if_false"
to be the "else" part. See the Excel Help for the IF function.

For those with F20, the field with the results [...] should
be blank. [....] If there's a value in Column F, it means
that the stock was sold and therefore there is no market
value change to put in Column I.

Oh, that is a very different story. Combining with your
original posting, does the following pseudocode match
your intention for column I (I2, for example):

if F2 0, then display blank,
else if E2 0, then display H2-E2, else display H2-D2

One way to write that in Excel is:

=IF(F20, "", IF(E20, H2-E2, H2-D2))