Excel: IF statement

Posted by MHZ on Stack Overflow See other posts from Stack Overflow or by MHZ
Published on 2012-12-10T23:01:38Z Indexed on 2012/12/10 23:03 UTC
Read the original article Hit count: 146

Filed under:

I am trying to write an excel if statement. I am new to using all the extra functionality Excel has. I am using a function called importXML(). I am trying to check whether a function I am using generates a "#VALUE!" error as follows:

if(
   importXML(B1,C1)!="#VALUE!" //check if no error generated, 
   importXML(B1,C1)//if no error is generated, use these cells in the function
   importXML(A1,C1)//else use these cells in the function
)

Is this possible? Am I using excels if statement correctly to check for errors?

© Stack Overflow or respective owner

Related posts about excel