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

 

[macropod]

Presumably this is for Excel.



Given your specs, the following formula works for values in H1 & L1:

=(H10)*(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" 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