Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
"Str8" wrote in message
... "bigwheel" wrote: "Str8" wrote: Heres what Im trying to do. Lets say in cell a1 is Monday and in b1 is Tuesday and in c3 I would like to say if a1 or b1 equals Moday OR Wednesday yes if not no? This formula would satisfy your conditions:- =IF(OR(OR(A1="Monday",A1="Wednesday"),OR(B1="Monda y",B1="Wednesday")),"Yes","No") Thanks for all the replies Ive give them a try. You don't, presumably, need OR three times; one would do. =IF(OR(A1="Monday",A1="Wednesday",B1="Monday",B1=" Wednesday"),"Yes","No") -- David Biddulph |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2 Nesting questions | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |