IF Statement

[Stclements1]

In column P, I want to change the current formula =IF(F3>0;((O3/H3)/F3)+D3;"0"), so that whilst doing the same calculation it also includes the text value in column C. If it says "BUY" it adds D3 and if the value in the relevant C cell says "SELL" it calculates -D3.
I did write IF(C3="BUY";(((O3/H3)/F3)+D3;O3/H3)F3)-D3) but that didn't work.
Please find the worksheet attached. Many thanks.

Main Trade sheet.xlsm
	K
21
Positions

 

[diddi]

try this

=IF(F3>0,IF(C3="BUY",((O3/H3)/F3)+D3,IF(C3="SELL",((O3/H3)/F3)-D3,"0")))

 

[Stclements1]

=IF(F3>0,IF(C3="BUY",((O3/H3)/F3)+D3,IF(C3="SELL",((O3/H3)/F3)-D3,"0")))

Perfect. many thanks.