vendredi 6 décembre 2019

How to create result from multiple if result neatly in Excel

I want to combine multiple result of if statement into a form of sentence.

Code:

=CONCAT("Fail column", IF($T3="No", " T", "")& IF($U3="No", ", U", "") & IF($W3<7, ", W", "") & IF($X3>3, ", X", "") & IF($AE3="No", ", AE", "") & IF($AF3="No", ", AF", ""))

If first statement return blank, the next statement would not show the comma at the beginning. And let say all pass, they would be shown as "Yes".

My expected output can be:

  1. Fail column T, U, W, X, AE, AF
  2. Fail column U, W, X, AE, AF
  3. Fail column T
  4. Fail column W, X
  5. Yes

Tq

Aucun commentaire:

Enregistrer un commentaire