| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement
I have an IF statement formula already and I wanted to know if I could insert
another one, inserting certain numbers. Example: 1101(data coming in) and I want to insert 310(for every one) in front while picking up the first four digits. The problem is that the data coming in is not always consistent. Below is my IF Statement: =IF(ISERR(VALUE(LEFT(A2752,1))2),H2751,IF(VALUE(L EFT(A2752,1))2,VALUE(LEFT(A2752,4)),VALUE(LEFT(A2 752,2)))) Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
| SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Threaded Mode
