Why is this giving me an error? C8 is blank and E8 has a 0 in it.
=IF(SUBSTITUTE(E8,",",".")-SUBSTITUTE(C8,",",".")<>0,SUBSTITUTE(E8,",",".")-SUBSTITUTE(C8,",","."),"0")
Note that E8-C8 normally produces 0, all I'm doing is trying to automagically adapt the euro , into the american .
Bookmarks