What IF statement
 

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

What IF statement
 

See reply in microsoft.public.office.misc

Please don't post the same question multiple times in different newsgroups - you can post to multiple newsgroups simultaneously, if
need be, so that an answer in one newsgroup propagates to all. You can do this by inserting all the newsgroups names into the
message header.


--
Cheers
macropod
[Microsoft MVP - Word]


"Beep Beep" wrote in message ...
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