Google Sheets – How to Fix Issues with SUBSTITUTE Function

formulasgoogle sheets

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).

Screenshot of the problem

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).

Related Topic