Help with nested IF for distinguishing between 4 and 5 digit numbers in a cell
We have a formula in this sheet that currently distinguishes between multiple PO#s in the PO column and separates them into individual columns when there's more than 1. In anticipation of using 5 digit POs alongside the standard 4 digits we currently use, we're having difficulty setting up a something like a nested countif formula to check when a number has 5 digits or 4 digits, then parsing them accordingly.
We've attached a screenshot with the current formula along with the columns in use. For context the formula first checks if the PO# cell is blank and if so adds an "x" to the related PO column for use on another sheet. Any assistance is greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!