I want to return multiple values for all the statements executed true. I am using the following formula:
=IF(
AND(I4=1,J4=1),"2G",
IF(
AND(Q4=1,V4=1),"3G",
IF(
AND(AC4=1,AG4=1),"4G",
"Other")))
However this is returning the first true value from the nested IF. I want to return all three values, 2G 3G 4G, if all are true. Something like concatenated result.
Aucun commentaire:
Enregistrer un commentaire