What IF statement

[Beep Beep]

Here is what I would like to do: Don’t know if an IF statement will suffice
here or not:
In column H I either have S1,000 or it is blank
Column J is blank
What I would do is if H(?) = $1,000 and L (?) is > than 100% then put $1,500
in Column J
Also if H(?) is blank and L(?) is > 100% put $2,500 in Column J
However if l(?) is <100% put zero in Column J

 

[macropod]

Presumably this is for Excel.

Given your specs, the following formula works for values in H1 & L1:
=(H1<>0)*(L1>100%)*1500+(H1=0)*(L1>100%)*2500
You don't say what should happen when L = 100%.

Note: As coded, H tests for either zero or any non-zero value.