I ran into a speed bump yesterday and today with a true or false statement from data in a single column containing a speed (see attached picture). Most, if not all, speeds are two digits in length; however, yesterday and today I had several speeds post in single-digit format (i.e., 3, 6, 8, etc.). What can I incorporate into the current formula =TEXT($G4,"##")>"63" that will check both single and double-digit numbers or pass over /avoid the single-digit number? This formula =TEXT($G4,"##")>"63" produces a "true" statement for a single-digit speed when it clearly is not >63 "MPH".
This does not work either =AND(TEXT($G4,"#")>"63",TEXT($G4,"##")>"63")
This does not work either =AND(TEXT($G4,"#")>"63",TEXT($G4,"##")>"63")