| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 70698 | 2006-07-13 00:25:00 | XL Function | B.M. (505) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 470468 | 2006-07-19 05:00:00 | Yes, = not required as is for start of equation, and we which to show argument | SolMiester (139) | ||
| 470469 | 2006-07-23 08:25:00 | if you want to test whether the cell is blank use the IsBlank() function. Should come out something like: =IF(ISBLANK(A1),"",--(OR(IF(ISERROR(SEARCH("76",A1)),0,1),IF(ISERROR(SEARCH("itm",A1)),0,1)))) Cheers Dave |
odyssey (4613) | ||
| 1 2 | |||||