View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default 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")))