| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple if's
I have to convert many accounts to a new account string. I have many
Or's. Is there a better way to code this? ( I actually have 16 Or's- I only show 4 for the example): For Each cll In Selection old = Right(cll, 4) If old = "0101" Or old = "0102" Or old = "0103" Or old = "0104" Then CONVERT CLL End If Next Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple IF's with an OR | Excel Worksheet Functions | |||
| Multiple IF's to Select a Value | Excel Worksheet Functions | |||
| Multiple If's and OR's | Excel Worksheet Functions | |||
| multiple IF's ? | Excel Worksheet Functions | |||
| Formula with multiple IF'S | Excel Discussion (Misc queries) | |||
Threaded Mode
