Need help again :D

[Smeeg]

I did get a great reply to my problem the other day - but unfortunately I made a mistake in my explanation :/ - this is the prob:

if anything is in cell A1 AND in cell B1 then show "ok" in cell C1
if anything is in cell A1 and NOT in cell B1 then show "add order" in cell C1
if nothing is in cell A1 and IS in cell B1 then show "add client" in cell C1
if nothing is in either cell A1 or B1 then show "add client add order" in cell C1

thanks again,

Smeeg

[JE McGimpsey]

One way:

=IF(COUNTA(A1:B1)=0,"ok",TRIM(IF(B1="","","add client") &
IF(A1="",""," add order")))

In article <[email protected]>,
Smeeg <[email protected]> wrote:

> I did get a great reply to my problem the other day - but unfortunately
> I made a mistake in my explanation :/ - this is the prob:
>
> if anything is in cell A1 AND in cell B1 then show "ok" in cell C1
> if anything is in cell A1 and NOT in cell B1 then show "add order" in
> cell C1
> if nothing is in cell A1 and IS in cell B1 then show "add client" in
> cell C1
> if nothing is in either cell A1 or B1 then show "add client add order"
> in cell C1
>
> thanks again,
>
> Smeeg

[Arvi Laanemets]

Hi

=IF(AND(A1<>"",B1<>""),"OK",IF(A1="","add client") & IF(AND(A1="",B1=""),"
","")) & IF(B1="","add order"))
, or
=CHOOSE(((A1="")*1+(B1="")*2)+1,"add client","add order","add order add
client","OK")


--
Arvi Laanemets
( My real mail address: arvil<at>tarkon.ee )



"Smeeg" <[email protected]> wrote in
message news:[email protected]...
>
> I did get a great reply to my problem the other day - but unfortunately
> I made a mistake in my explanation :/ - this is the prob:
>
> if anything is in cell A1 AND in cell B1 then show "ok" in cell C1
> if anything is in cell A1 and NOT in cell B1 then show "add order" in
> cell C1
> if nothing is in cell A1 and IS in cell B1 then show "add client" in
> cell C1
> if nothing is in either cell A1 or B1 then show "add client add order"
> in cell C1
>
> thanks again,
>
> Smeeg
>
>
> --
> Smeeg
> ------------------------------------------------------------------------
> Smeeg's Profile:
> http://www.excelforum.com/member.php...o&userid=29099
> View this thread: http://www.excelforum.com/showthread...hreadid=488673
>

[JE McGimpsey]

Oops, had it backwards...

IF(COUNTA(A1:B1)=2,"ok",TRIM(IF(B1="","add client","") & IF(A1="",
"_add order", "")))


where _ is substituted for a space character to avoid unfortunate
linewrap.

In article <[email protected]>,
JE McGimpsey <[email protected]> wrote:

> =IF(COUNTA(A1:B1)=0,"ok",TRIM(IF(B1="","","add client") &
> IF(A1="",""," add order")))

[Smeeg]

great. thanks for that.

the 'choose' formula worked a treat.

Smeeg