Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
Formula works in some cells, doesn't in other | New Users to Excel | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |