I'm trying to setup a transaction report that keeps track of the total
transaction cost plus/minus fees. In my excel sheet I have quantity, price,
type (buy/sell), status (executed) and a total column.

In the total column, the formula I'm looking for is "if E5="executed" then
quantity*price + buy or quantity*price-sell)

The TRUE argument is "executed", if "executed" then buy or sell is true. The
argument is FALSE if "executed" is not in the parameter.

Any suggestions?