Utah contains 5 metropolitan areas (Logan, Ogden-Clearfield, Salt Lake City, Provo-Orem, and St. George), and 6 micropolitan areas (Brigham City, Heber, Vernal, Price, Richfield, and Cedar City).tah has a population of about 2.9 million, approximately 80% of whom live along the Wasatch Front, centering on Salt Lake City. Utah is bordered by Colorado to the east, Wyoming to the northeast, Idaho to the north, Arizona to the south, and Nevada to the west. It also touches a corner of New Mexico in the southeast.
Question: In Microsoft Excel, I need a formula that does the following: IF the value in cell A1 is BLANK, then return BLANK. IF the value in cell A1 is TEXT, then return TEXT. IF the value in cell A1 is NUMERIC, then return NUM.
Important points to remember about Excel formulas: 1  formulas in Excel always begin with the equal sign 2  ( = ); the formula is always typed into the cell where you want the answer to appear; 3  the subtraction sign in Excel is the dash 4  ( - ); the formula is completed by pressing the Enter key on the keyboard.