If I have an array in excel like
A B C D E F G H
1 1 0 0 0 1 0 0
and I want to check the condition that IF even one 1 exists I want to get output as BUY, and if all are 0, then not buy. Can you please tell me how to get this? Thanks in advance.
Aucun commentaire:
Enregistrer un commentaire