| Home |
| Search |
| Today's Posts |
|
#17
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
unions, intersections or array constants
"T. Valko" wrote...
.... Alternatives: If the cell contains a number from 1 to 12 one or the other formats is applied. .... Good point. blue: =IF(ISTEXT($AK$2),MOD(MONTH($AK$2&"-1"),2)=1) green: =IF(ISTEXT($AK$2),MOD(MONTH($AK$2&"-1"),2)=0) These allow whitespace in AK2. If that's not OK, then change the second cell references to SUBSTITUTE($AK$2," ","%"). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula constants? | Excel Worksheet Functions | |||
| Constants in Excel | Excel Discussion (Misc queries) | |||
| how to find intersections points of lines in charts | Charts and Charting in Excel | |||
| Intersections | Excel Discussion (Misc queries) | |||
| constants | Excel Discussion (Misc queries) | |||
![Harlan Grove[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
