vendredi 17 novembre 2017

If I have an array in excel like (1,1,0,0,0,1,0,0) a

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