Concatenation issues

[ecnewb]

Trying to use CONCATENATE.

Goal: IF A1 and B1 >0, then concatenate, separated by a comma into C1.
If A1 or B1>0, but not both, then copy the value of A1 or B1, whichever is >0 into C1.
If A1 and B1=0 then leave C1 blank.

So far have got to: =IF(AND(A1>0, B1>0),CONCATENATE(A1,",",B1)," ")
The issue I am running into is accommodating the middle argument.

Any and all help appreciated.

 

[MattH1]

Let me know if this works.

=IF(AND($A$1>0, $B$1>0),CONCATENATE($A$1,",",$B$1),IF(AND($A$1=0,$B$1>0),$B$1,IF(AND($A$1>0,$B$1=0),$A$1,"")))

 

[ecnewb]

Almost.

Goal: IF A1 and B1 >0, then concatenate, separated by a comma into C1. DONE
If A1 or B1>0, but not both, then copy the value of A1 or B1, whichever is >0 into C1. 1/2 DONE When A>0 and B=0, then A is copying to C1. BUT When A=0 and B>0, B is not copying to C.
If A1 and B1=0 then leave C1 blank. DONE

So very impressed so far. Thank you.

 

[MattH1]

Almost.

Goal: IF A1 and B1 >0, then concatenate, separated by a comma into C1. DONE
If A1 or B1>0, but not both, then copy the value of A1 or B1, whichever is >0 into C1. 1/2 DONE When A>0 and B=0, then A is copying to C1. BUT When A=0 and B>0, B is not copying to C.
If A1 and B1=0 then leave C1 blank. DONE

So very impressed so far. Thank you.

Double check that. The formula works just fine for me. If it still doesn't work, do the following:

1. Enter 0 into cell A1 and 1 into Cell B1. Tell me what output you get.
2. Enter 1 into cell A1 and 0 into Cell B1. Tell me what output you get.

This will help me understand what went wrong in the formula, though I have no wrong numbers when I use it myself.

The formula below is Red/Bolded where B1 should be output if A=0 and B>0, as you said is not working. It shouldn't cause any errors.
=IF(AND($A$1>0, $B$1>0),CONCATENATE($A$1,",",$B$1),IF(AND($A$1=0,$B$1>0),$B$1,IF(AND($A$1>0,$B$1=0),$A$1,"")))

 

[Rick Rothstein]

Trying to use CONCATENATE.

Goal: IF A1 and B1 >0, then concatenate, separated by a comma into C1.
If A1 or B1>0, but not both, then copy the value of A1 or B1, whichever is >0 into C1.
If A1 and B1=0 then leave C1 blank...

Give this formula a try...

=MID(IF(A1="","",","&A1)&IF(B1="","",","&B1),2,99)

 

[LockeGarmin]

The following may cover some edge cases in your data.

=TEXT(A1,"0;;;")&REPT(",",TEXT(A1,"\1;\0;\0;\0")*TEXT(B1,"\1;\0;\0;\0"))&TEXT(B1,"0;;;")

 

[ecnewb]

It worked Matt. Thank you so very much!

 

[Rick Rothstein]

It worked Matt. Thank you so very much!

I made a mistake in the formula I posted in Message #5, here is the corrected version which you may want to consider given its simplicity...

=MID(IF(A1<=0,"",","&A1)&IF(B1<=0,"",","&B1),2,99)