How to check why a formula isnt working?

Hi Cassy

Thank you for your question.

Normally you will need to look at the function and troubleshoot this yourself. Common mistakes are:

- missing brackets, or not including enough brackets if you are creating a nested if funtion

- if you are using numbers as part of any of the arguments of the function, including commas within the numbers (e.g. 1,000 instead of 1000) will confuse Excel as it will think where the comma is within the number is where you have ended that particular argument

- not including a 'value if false' argument as the final argument in a nested if function.

- putting in the wrong symbol, e.g using > as less than rather than greater than.

I hope this helps.

Amanda