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.
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.