VBA auto-sort not working when the "IFERROR" part of the formula is in effect

I have VBA code to auto-sort a league table.

My code is:

Please Login or Register  to view this content.

The formula in the range column that dictates the sort is:

Please Login or Register  to view this content.

The sort works perfectly when the standard part of the formula is able to be used:

Please Login or Register  to view this content.

But when there is an error (this is because that particular team have not yet played a fixture so far this season), everything else sorts correctly and all teams that have not yet played and require the =IFERROR are sat at the top of the pile which is causing issues with the other stats in the league table.

Any suggestions of how I can get the IFERROR teams to be included in the auto-sort? They are displaying the correct value from the formula however, not the correct playing in the league which means other formulas are now referring to the incorrect cells.

Thanks

Try using 0 (no quotes) instead of ".000". When you use ".000" it is interpreted as a string, and won't sort with numbers where you might expect. If you have the cell formatted as number with three decimal places then it will display as 0.000.