mardi 11 septembre 2018

If a cell with text and numbers contains a number greater than 10, then "this", if not then "that" in Excel

As stated in the tile, if cell in column A containing text string and number(s) has a number greater than 10,TRUE,FALSE

/A/                        /B/

W MICH by 1 @ syr         FALSE    
ten @ W VIRG by 18        TRUE    
iowa @ N ILL by 9         FALSE    
VANDY by 11 @ mid ten st  TRUE

enter image description here

Aucun commentaire:

Enregistrer un commentaire