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: 237
excel
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
