Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
good day,
A 1 2 3 What I want are as follows if B1 = 1,2 or 3 it should show as true under the "and" formula. rgds jules |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Not sure what you mean by: it should show as true under the "and" formula.
Maybe you mean this: =OR(B1={1,2,3}) -- Biff Microsoft Excel MVP "ekkeindoha" wrote in message ... good day, A 1 2 3 What I want are as follows if B1 = 1,2 or 3 it should show as true under the "and" formula. rgds jules |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selection | New Users to Excel | |||
Identifying a selection of a selection of a range | Excel Worksheet Functions | |||
selection in VBA | Excel Discussion (Misc queries) | |||
Changing Selection for the "Center Across Selection" alignment | Excel Discussion (Misc queries) | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions |