Trying to eliminate unreasonable +ve and -ve percentage results

Hi Jason

Thanks for getting in touch. You can achieve what you want through Custom Formats in Excel.

I think I've interpreted your criteria correctly but as you'll see in the example it's quite easy to change.

Highlight your percentages, right-click and choose Format Cells. On the Number tab choose Custom. Under Type enter the following:

[<=-999]"N/A";[>=999]"N/A";0.00%

This uses IF THEN ELSE logic, separated by semicolons. If the value is less than -999 replace it with N/A. If the value is greater than 999 then replace it with N/A. Otherwise format it as regular 2dp percentage.

This can be a bit odd to get your head around but take a look, try it in your workbook and see if it gives you the desired results. Let me know if you need further help.

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