=IF(OR(AND(A1="",B1=""),AND(A1<"",B1<"")),"ab",I F(AND(A1<"",B1=""),"a","b
"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Smeeg" wrote in
message ...

if anything is in cell A1 AND in cell B1 then show "ab" in cell C1
if anything is in cell A1 and NOT in cell B1 then show "a" in cell C1
if nothing is in cell A1 and IS in cell B1 then show "b" in cell C1
if nothing is in either cell A1 or B1 then show "ab" in cell C1

Whats the formala I need to put in C1 to make the above rules work?

Thankinoo.

AJ


--
Smeeg
------------------------------------------------------------------------
Smeeg's Profile:
http://www.excelforum.com/member.php...o&userid=29099
View this thread: http://www.excelforum.com/showthread...hreadid=488206