Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Smeeg
 
Posts: n/a
Default Please help me with a formula


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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default Please help me with a formula

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

--
Kind regards,

Niek Otten

"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



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Please help me with a formula

=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



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Please help me with a formula

Smartypants :-))


"Niek Otten" wrote in message
...
=IF(A1="","","a")&IF(B1="","","b")

--
Kind regards,

Niek Otten

"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





  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Smeeg
 
Posts: n/a
Default Please help me with a formula


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
------------------------------------------------------------------------
Smeeg's Profile: http://www.excelforum.com/member.php...o&userid=29099
View this thread: http://www.excelforum.com/showthread...hreadid=488206



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Smeeg
 
Posts: n/a
Default Please help me with a formula


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

  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default Please help me with a formula

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

--
Kind regards,

Niek Otten

"Smeeg" wrote in
message ...

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



  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Smeeg
 
Posts: n/a
Default Please help me with a formula


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


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF formula? meris Excel Worksheet Functions 1 September 6th 05 07:14 AM
Formula works in some cells, doesn't in other Wowbagger New Users to Excel 13 June 30th 05 03:21 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM
Problem with VBA returning the contents of a long formula. [email protected] Excel Discussion (Misc queries) 2 February 23rd 05 01:14 AM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 05:37 PM


All times are GMT +1. The time now is 03:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"