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.

--
Cheers
macropod
[Microsoft MVP - Word]


"Beep Beep" <BeepBeep@discussions.microsoft.com> wrote in message news:C38A809C-9556-4643-8CDA-517694B19296@microsoft.com...
> 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
>