Here is what I would like to do: Dont 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