mardi 21 mai 2019

Better to use arrayformula or?

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