| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference Date with Or Function
I'm trying to use an Or() function to reference a cell which is formated
as a date. I get an error every time I try. If(OR(A2={B2,B6}),"text","") A2, B2 and B6 are all dates. rac |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reference Date with Or Function
=IF(OR(A2=B2,A2=B6)),"text","")
-- Kind regards, Niek Otten Microsoft MVP - Excel "rac" wrote in message ... | I'm trying to use an Or() function to reference a cell which is formated | as a date. I get an error every time I try. | | If(OR(A2={B2,B6}),"text","") | | A2, B2 and B6 are all dates. | | | rac |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reference Date with Or Function
=IF(OR(A2=B2,(A2=B6)),"text","")
Gord Dibben MS Excel MVP On Thu, 16 Nov 2006 16:33:00 -0500, rac wrote: I'm trying to use an Or() function to reference a cell which is formated as a date. I get an error every time I try. If(OR(A2={B2,B6}),"text","") A2, B2 and B6 are all dates. rac |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reference Date with Or Function
Gord Dibben wrote:
=IF(OR(A2=B2,(A2=B6)),"text","") Gord Dibben MS Excel MVP On Thu, 16 Nov 2006 16:33:00 -0500, rac wrote: I'm trying to use an Or() function to reference a cell which is formated as a date. I get an error every time I try. If(OR(A2={B2,B6}),"text","") A2, B2 and B6 are all dates. rac Thanks Much! It seems so simple now. rac |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reference Date with Or Function
You have a correct formula. All you have to commit ctrl+shift+enter (not just
enter) "rac" wrote: I'm trying to use an Or() function to reference a cell which is formated as a date. I get an error every time I try. If(OR(A2={B2,B6}),"text","") A2, B2 and B6 are all dates. rac |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MATCH FUNCTION AND SERIAL DATE CONFLICTS | Excel Worksheet Functions | |||
| "year" date function | Excel Discussion (Misc queries) | |||
| Date formulas | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Hybrid Mode
