Please help me with a formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Smeeg - 25 Nov 2005 16:52 GMT

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

Signature

Smeeg

Reply to this Message

Bob Phillips - 25 Nov 2005 17:09 GMT

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

Signature

HTH

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

> 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
[quoted text clipped - 6 lines]
>
> AJ

Reply to this Message

Niek Otten - 25 Nov 2005 17:09 GMT

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

Signature

Kind regards,

Niek Otten

> 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
[quoted text clipped - 6 lines]
>
> AJ

Reply to this Message

Bob Phillips - 25 Nov 2005 17:33 GMT

Smartypants :-))

> =IF(A1="","","a")&IF(B1="","","b")
>
[quoted text clipped - 8 lines]
> >
> > AJ

Reply to this Message

Smeeg - 28 Nov 2005 08:23 GMT

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

Signature

Smeeg

Reply to this Message

Smeeg - 28 Nov 2005 11:57 GMT

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.

A

Reply to this Message

Niek Otten - 28 Nov 2005 12:26 GMT

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

Signature

Kind regards,

Niek Otten

> Ooops, I made a mistake in my last rule! sorry...
>
[quoted text clipped - 8 lines]
>
> AJ

Reply to this Message

Smeeg - 28 Nov 2005 12:58 GMT

thanks again for the quick reply - but I'm an idiot. I was trying to b
clever by saying put result a, b, ab, ba. but thats not what I reall
wanted. Sorry to be a pain, but this is exactly what I need, rathe
than just vague example. the formula's you have provided seem to stic
'a' and 'b' together when the results needed to be 'ab' but thats no
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" i
cell C1
if nothing is in cell A1 and IS in cell B1 then show "add client" i
cell C1
if nothing is in either cell A1 or B1 then show "add client add order
in cell C1

thanks again,

Smee

Reply to this Message