| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make IF logical expression equal to any 5 digit value
I wanted to see if there is any way to make the logical expression of an
IF statement equal to any 5 digit value. Ex: =IF(B2=?????, .... If the value in B2 is a 5 digit value then it is true and false if it is not. -yalex --- Message posted from http://www.ExcelForum.com/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to make IF logical expression equal to any 5 digit value
Try something like the following formula:
=IF(AND(ISNUMBER(B2),LEN(B2)=5),"yes","no") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "yalex " wrote in message ... I wanted to see if there is any way to make the logical expression of an IF statement equal to any 5 digit value. Ex: =IF(B2=?????, .... If the value in B2 is a 5 digit value then it is true and false if it is not. -yalex --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to make IF logical expression equal to any 5 digit value
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using cell reference with logical operator in DGET expression | Excel Worksheet Functions | |||
| logical expression help please | New Users to Excel | |||
| Can I use more complex logical expression for sumif as creteria? | Excel Worksheet Functions | |||
| How do you determine if a field is blank in a logical expression. | Excel Discussion (Misc queries) | |||
| variable not equal to expression | Excel Programming | |||
Linear Mode
