mercredi 20 avril 2016

Excel: Nested IF statement if all condition are true return all true values

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