Please help me with a formula

[Smeeg]

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

[Niek Otten]

=IF(A1="","","a")&IF(B1="","","b")

--
Kind regards,

Niek Otten

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

[Bob Phillips]

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

--

HTH

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


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

[Bob Phillips]

Smartypants :-))


"Niek Otten" <[email protected]> wrote in message
news:[email protected]...
> =IF(A1="","","a")&IF(B1="","","b")
>
> --
> Kind regards,
>
> Niek Otten
>
> "Smeeg" <[email protected]> wrote in
> message news:[email protected]...
> >
> > 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
> >
>
>

[Smeeg]

thanks for that peeps.

I knew had something to do with nested IFs, but didn't know how to add the 'and's or 'or's :D

Smeeg

[Smeeg]

Ooops, I made a mistake in my last rule! sorry...

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 "ba" in cell C1

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

Thankinoo.

AJ

[Niek Otten]

=IF(AND(A1="",B1=""),"ba",IF(A1<>"","a","")&IF(B1<>"","b",""))

--
Kind regards,

Niek Otten

"Smeeg" <[email protected]> wrote in
message news:[email protected]...
>
> Ooops, I made a mistake in my last rule! sorry...
>
> 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 "ba" 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
>

[Smeeg]

thanks again for the quick reply - but I'm an idiot. I was trying to be clever by saying put result a, b, ab, ba. but thats not what I really wanted. Sorry to be a pain, but this is exactly what I need, rather than just vague example. the formula's you have provided seem to stick 'a' and 'b' together when the results needed to be 'ab' but thats not quite what I wanted :D


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