Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF Formula
I need to set up an IF formula for a series on account numbers- the first 4
digits of the # are the same, the last 2 change but all are included in the answer. I have several series of numbers to include: example: 1234-01 through 1234-99 and 2007-01 through 2007-99 and 3010-01 through 3010-99 Any help you could give me would be appreciated |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF Formula
What would you like the formula to do?
"ESSO" wrote: I need to set up an IF formula for a series on account numbers- the first 4 digits of the # are the same, the last 2 change but all are included in the answer. I have several series of numbers to include: example: 1234-01 through 1234-99 and 2007-01 through 2007-99 and 3010-01 through 3010-99 Any help you could give me would be appreciated |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF Formula
Hi ESSO,
If your data is in column A, enter the formula in B1 and drag down: =IF(OR(LEFT(A1,4)="1234",LEFT(A1,4)="2007",LEFT(A1 ,4)="3010"),"your message here","your opposite message here") This will display your message if the data in column A starts with 1234, 2007 or 3010. Ewan. "ESSO" wrote: I need to set up an IF formula for a series on account numbers- the first 4 digits of the # are the same, the last 2 change but all are included in the answer. I have several series of numbers to include: example: 1234-01 through 1234-99 and 2007-01 through 2007-99 and 3010-01 through 3010-99 Any help you could give me would be appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | 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) |