| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Condition
I have a column A with dates. If the date on that column is less than
08/01/2008, on column B I want it to state "N". How do I accomplish this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Condition
I assume you mean 1st August? for B2 try
=IF(A1<DATE(2008,8,1),"N","") "Erlang" wrote: I have a column A with dates. If the date on that column is less than 08/01/2008, on column B I want it to state "N". How do I accomplish this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Condition
On Jul 23, 9:16 am, Erlang wrote:
I have a column A with dates. If the date on that column is less than 08/01/2008, on column B I want it to state "N". How do I accomplish this? =IF(ISNUMBER(A1),IF(A1<DATE(2008,1,8),"N",""),"") for 8th Jan 2008 =IF(ISNUMBER(A1),IF(A1<DATE(2008,8,1),"N",""),"") for 1st Aug 2008 Ken Johnson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if condition | Excel Discussion (Misc queries) | |||
| lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
| Combine an OR condition with an AND condition | Excel Discussion (Misc queries) | |||
| Condition 1 overules condition 2? | Excel Worksheet Functions | |||
| Condition IF | Excel Discussion (Misc queries) | |||
Linear Mode
