| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF(AND function is not working
Why won't my IFAND function work. below are the columns in my worksheet and
example of the data that is in each column. However, my formula is returning a " " or blank cell instead of the number 1 for dates that are greater than 12/1/2004 and less than 1/1/2006 Function Costcenter unit date A B C D IF(AND(D212/1/2004,D2<1/1/2006),1,"") 1200120 3465 8/1/2005 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| click & drag not working | Excel Discussion (Misc queries) | |||
| amount of working days per month | Excel Discussion (Misc queries) | |||
| Calculation with Working day of the year | Excel Discussion (Misc queries) | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| Working time and days | Excel Worksheet Functions | |||
Threaded Mode
