IF Function Formula assistance required - THANK YOU

[KALAF]

Hi All,

I know what I am wanting to do but I can't find the right written expression to generate the results.

What I wanting is column J to do the following:


If F2>1 then D2 – F2 or if F2 is blank D2+E2*H2

Sample

Column A	Column B	Column C	Column D	Column E	Column F	Column G	Column H	Column !	Column J
Identifier	#	Date	Value	Position	Negative	Positive	%		Result
ABC	1	1/1/17	1000	50	50	FALSE	60%		950
ABC	2	1/1/17	950	100		60.00	60%		1,110.00
ABC	3	1/1/17	1110	50		30.00	60%		1,190.00
ABC	4	1/1/17	1190	50	50	FALSE	60%		1,140.00
ABC	5	1/1/17	1140	100		60.00	60%		1,300.00

<!--StartFragment--> <colgroup><col width="65" span="10" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>

<colgroup><col width="65" span="11" style="width:65pt"></colgroup><tbody>
<!--EndFragment--></tbody>

 

[Trevor_S]

Formula is
=if(F2>1,D2–F2,if(F2="",D2+E2*H2,""))

If neither criteria is met (I.e. F2 is less than or equal to 1), the result will be a blank.