Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help again :D
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help again :D
One way:
=IF(COUNTA(A1:B1)=0,"ok",TRIM(IF(B1="","","add client") & IF(A1="",""," add order"))) In article , Smeeg 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help again :D
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<attarkon.ee ) "Smeeg" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help again :D
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 , JE McGimpsey wrote: =IF(COUNTA(A1:B1)=0,"ok",TRIM(IF(B1="","","add client") & IF(A1="",""," add order"))) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help again :D
great. thanks for that. the 'choose' formula worked a treat. Smeeg -- Smeeg ------------------------------------------------------------------------ Smeeg's Profile: http://www.excelforum.com/member.php...o&userid=29099 View this thread: http://www.excelforum.com/showthread...hreadid=488673 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|