What IF statement

  • Thread starter Thread starter Beep Beep
  • Start date Start date
B

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
 
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.
 
Back
Top