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:
- Fail column T, U, W, X, AE, AF
- Fail column U, W, X, AE, AF
- Fail column T
- Fail column W, X
- Yes
Tq
Aucun commentaire:
Enregistrer un commentaire