View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default multiple IF Statements

Good morning all.

I did a quick search for the answer to my question, unfortuantely I was
unable to find exactly what i was looking for. I know I have done it before i
am just drawing a blank on how to do it now. Below is what I would like to
do, could someone help me convert it to an if statement?

if worksheet 1 a1 = "" then "" otherwise if worksheet 1 a1 = worksheet 2 a2
then 1 otherwise 0.

Thanks in advance for any help you may beable to offer.
Steve