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

[TABLE="width: 650"]
<!--StartFragment--> <colgroup><col width="65" span="10" style="width:65pt"> </colgroup><tbody>[TR]
[TD="width: 65"][/TD]
[TD="width: 65"][/TD]
[TD="width: 65"][/TD]
[TD="width: 65"][/TD]
[TD="width: 65"][/TD]
[TD="width: 65"][/TD]
[TD="width: 65"][/TD]
[TD="width: 65"][/TD]
[TD="width: 65"][/TD]
[TD="width: 65"][/TD]
[/TR]
[TR]
[TD="class: xl66"]Column A[/TD]
[TD="class: xl66"]Column B[/TD]
[TD="class: xl66"]Column C[/TD]
[TD="class: xl66"]Column D[/TD]
[TD="class: xl66"]Column E[/TD]
[TD="class: xl66"]Column F[/TD]
[TD="class: xl66"]Column G[/TD]
[TD="class: xl66"]Column H[/TD]
[TD="class: xl66"]Column ![/TD]
[TD="class: xl66"]Column J[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Identifier[/TD]
[TD]#[/TD]
[TD]Date[/TD]
[TD]Value[/TD]
[TD]Position[/TD]
[TD]Negative[/TD]
[TD]Positive[/TD]
[TD]%[/TD]
[TD][/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD="align: right"]1[/TD]
[TD="class: xl63, align: right"]1/1/17[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[TD="class: xl64, align: center"] FALSE [/TD]
[TD="class: xl65, align: right"]60%[/TD]
[TD="class: xl65"][/TD]
[TD="align: right"]950[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD="align: right"]2[/TD]
[TD="class: xl63, align: right"]1/1/17[/TD]
[TD="align: right"]950[/TD]
[TD="align: right"]100[/TD]
[TD][/TD]
[TD="class: xl64, align: right"] 60.00 [/TD]
[TD="class: xl65, align: right"]60%[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl64, align: right"] 1,110.00 [/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD="align: right"]3[/TD]
[TD="class: xl63, align: right"]1/1/17[/TD]
[TD="align: right"]1110[/TD]
[TD="align: right"]50[/TD]
[TD][/TD]
[TD="class: xl64, align: right"] 30.00 [/TD]
[TD="class: xl65, align: right"]60%[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl64, align: right"] 1,190.00 [/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD="align: right"]4[/TD]
[TD="class: xl63, align: right"]1/1/17[/TD]
[TD="align: right"]1190[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[TD="class: xl64, align: center"] FALSE [/TD]
[TD="class: xl65, align: right"]60%[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl64, align: right"] 1,140.00 [/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD="align: right"]5[/TD]
[TD="class: xl63, align: right"]1/1/17[/TD]
[TD="align: right"]1140[/TD]
[TD="align: right"]100[/TD]
[TD][/TD]
[TD="class: xl64, align: right"] 60.00 [/TD]
[TD="class: xl65, align: right"]60%[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl64, align: right"] 1,300.00 [/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]


[TABLE="width: 715"]
<colgroup><col width="65" span="11" style="width:65pt"></colgroup><tbody> [TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]

 

[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.