Would this code be better rewritten to use an array formula or better left as it is?
=IF(ISBLANK(D4),"",IF(AND(D4="Long", G4<=E4), "No trade", IF(AND(D4="Short", G4>=E4), "No trade", IF(AND(I4>=E4, H4<=E4), "Target Hit", "Active"))))
Aucun commentaire:
Enregistrer un commentaire