| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date logic
I want to test if a date is in first quarter, and if so, place value of a
cell into another. Otherwise, make it zero. A1 has date, column B1 has value. In C1 I put: =if(1/1/2009<=a1<4/1/2009,b1,0). This doesn't work, always says 0. What am I doing wrong? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOGIC | Excel Discussion (Misc queries) | |||
| I Then logic help | Excel Worksheet Functions | |||
| Logic please | Excel Discussion (Misc queries) | |||
| If Then logic not enough | Excel Discussion (Misc queries) | |||
| IF THEN LOGIC | Excel Discussion (Misc queries) | |||
Threaded Mode
