Using the CONCATENATE function nested in an IF function

Hello All, first post.

Is it possible to use an IF formula and based on the result add an additional letter to a cell?


I want to do something like (assume this formula is in cell A10):

=IF(A1>0,CONCATENATE("E"),IF B1>0,CONCATENATE("K"), ""))

So that if A1 and B1 are greater than zero, then A10 displays "E,K" and if only one or the other is greater than zero, only that letter shows up in cell A10.

Help?
Brian

In the attached PNG, F10 will display the letters based on weather I10:Q10 have a number in the cell

You could try a formula like this:

=SUBSTITUTE(IF(I10>0,",E","")&IF(J10>0,",K","")&IF(K10>0,",L",""),",","",1)

repeat the red bold part for all additional cells up to Q10