Hi,
I m having some trouble solving that DIV0 error, I checked different examples but cant find out how to solve it
= IF(E17="LONG",((I17-G17)/G17),ABS(I17-G17)/G17)
I get a DIV0 when the E17 is blank
I d like excel to return 0 if E17 is blank, if you have any idea :
Cheers
Bookmarks