IF Statements...I think

[kevinknight09]

I would like to create an IF statement such that IF A1 is not equal t
nil or A2 is not equal to nil then A3 will display an X. In case thi
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 Knigh

 

[Alan]

=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" <[email protected]>
wrote in message
news:[email protected]...

 

[Bob Phillips]

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

--

HTH

Bob Phillips

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

"kevinknight09" <[email protected]>
wrote in message
news:[email protected]...