I'm having problems using the SUBSTITUTE function as part of a formula. On it's own, SUBSTITUTE returns the desired output (i.e. in cell O3), but when combined in a formula, 0 is outputted (i.e. cell P3).
For informatation, the formula in cell O3 is
=IF(ISNUMBER(N3), N3-SUBSTITUTE(M3, "+", ""), "")
Best Answer
I think you are getting the correct answer but .2857 is being rounded down to less than £1! (ie it is just the formatting).