IF Statements...I think
 

I would like to create an IF statement such that IF A1 is not equal to
nil or A2 is not equal to nil then A3 will display an X. In case this
is not clear I have listed a couple of examples below:

Example 1
A1=""
A2=""
therefore A3=""

Example 2
A1=5.5
A2=""
therefore A3=X

Example 3
A1=""
A2=Kevin
therefore A3=X

Example 4
A1=5.5
A2=Kevin
therefore A3=X

Thank you in advance.

Kevin Knight


--
kevinknight09
------------------------------------------------------------------------
kevinknight09's Profile: http://www.excelforum.com/member.php...o&userid=37024
View this thread: http://www.excelforum.com/showthread...hreadid=567602

IF Statements...I think
 

=IF(OR(A1="",A2=""),"X","")
or if you want to display an error message,
=IF(OR(A1="",A2=""),"X","You're error messgage, formula or whatever")
Regards,
Alan.
"kevinknight09"
wrote in message
news:kevinknight09.2bxh0t_1154547628.2666@excelfor um-nospam.com...

I would like to create an IF statement such that IF A1 is not equal to
nil or A2 is not equal to nil then A3 will display an X. In case this
is not clear I have listed a couple of examples below:

Example 1
A1=""
A2=""
therefore A3=""

Example 2
A1=5.5
A2=""
therefore A3=X

Example 3
A1=""
A2=Kevin
therefore A3=X

Example 4
A1=5.5
A2=Kevin
therefore A3=X

Thank you in advance.

Kevin Knight


--
kevinknight09
------------------------------------------------------------------------
kevinknight09's Profile:
http://www.excelforum.com/member.php...o&userid=37024
View this thread: http://www.excelforum.com/showthread...hreadid=567602

IF Statements...I think
 

IF(AND(A1="",A2=""),"","X")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"kevinknight09"
wrote in message
news:kevinknight09.2bxh0t_1154547628.2666@excelfor um-nospam.com...

I would like to create an IF statement such that IF A1 is not equal to
nil or A2 is not equal to nil then A3 will display an X. In case this
is not clear I have listed a couple of examples below:

Example 1
A1=""
A2=""
therefore A3=""

Example 2
A1=5.5
A2=""
therefore A3=X

Example 3
A1=""
A2=Kevin
therefore A3=X

Example 4
A1=5.5
A2=Kevin
therefore A3=X

Thank you in advance.

Kevin Knight


--
kevinknight09
------------------------------------------------------------------------
kevinknight09's Profile:
http://www.excelforum.com/member.php...o&userid=37024
View this thread: http://www.excelforum.com/showthread...hreadid=567602