IF Statement

[Kingdom]

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?

 

[Bernard Liengme]

Not very clear:

Is this the scenario:
IF E5 = "executed" then
F5 gets price*quantity
ELSE
F5 gets nothing
END if
Then use =IF(D5="executed",, A5*B5 ,"")
-----------------------------
But if buy and sell come into play
IF E5 = "executed" then
IF c5 = "buy: then
F5 gets price*quantity
ELSE
F5 gets price*quality ' but here is
only one price field !
END IF
ELSE
F5 gets nothing
END if

=IF(D5="executed",IF(C5="buy",A5*B5,A5*B5),"") ' same answer no
matter what is in C5 !

best wishes

 

[FSt1]

hi
can we see examples of the data.
also what results are you expecting if true and what results are you
expecting if false.
i may be confused but there may be a problem with this part...
if (E5="executed" then quantity*price + buy or quantity*price-sell)

regards
FSt1