IF Errors

Hi Michael

Thanks for getting in touch. Assuming you are using Excel 2007 or later, I recommend the IFERROR function.

When one of your formulas is generating an error, wrap it in an IFERROR function to remove this issue. For example, if an AVERAGE function is causing problems and you want it to have a 0 (zero) in place of an error, you replace it with the following:

=IFERROR(AVERAGE(C5:C9),0)

Substitute the AVERAGE function with the problematic function, and the zero with the desired replacement message.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector