Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with a multiple OR statement.
I need to construct a multiple OR statement that looks at the first 5
characters of a cell (G16) and if it is Table, Day-T or Eveni, then expression 1, otherwise expression 2. Having asked a colleague, they have come up with:- =IF(OR(LEFT(G16,5)="Table€¯,LEFT(G16,5)="Day-T€¯, LEFT(G16,5)="Eveni),expression 1,expression 2) Is there an easier way to write the above? Any assistance offered would be welcome. Regards PM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Statement with multiple conditions | Excel Discussion (Misc queries) | |||
Rebate incentive - Multiple tier payback - Confusing if Statement | Excel Discussion (Misc queries) | |||
link multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
COUNTIF Statement with Multiple Conditions in Different Ranges | Excel Worksheet Functions | |||
IF Statement that's conditional on multiple IF Stmts in other cell | Excel Worksheet Functions |