Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting formulas
Currently, these formulas are in D1, E1, D2, E2, D3, E3, D4 and E4,
respectively: =IF(LEFT(A1,1)="1",IF(LEFT(C1,1)="0",LEFT(C1,3)&MI D(C1,5,3),"000000")) =IF(LEFT(A1,1)="1",IF(LEFT(C1,1)="0","0000000","0" &LEFT(C1,2)&MID (C1,4,4))) =IF(LEFT(A2,1)="6","000000","000000") =IF(LEFT(A2,1)="6",IF(LEFT(C2,1)="0","0"&LEFT(C2,3 )&MID (C2,5,3),"0"&LEFT(C2,2)&MID(C2,4,4))) =IF(LEFT(A3,1)="1",IF(LEFT(C3,1)="0",LEFT(C3,3)&MI D(C3,5,3),"000000")) =IF(LEFT(A3,1)="1",IF(LEFT(C3,1)="0","0000000","0" &LEFT(C3,2)&MID (C3,4,4))) =IF(LEFT(A4,1)="6","000000","000000") =IF(LEFT(A4,1)="6",IF(LEFT(C4,1)="0","0"&LEFT(C4,3 )&MID (C4,5,3),"0"&LEFT(C4,2)&MID(4,4,4))) How can I create one formula by nesting each pair of formulas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting formulas
It isn't clear what you want to do with the nesting. You currently have one
result in D1 and a different result in E1. What result do you want, and in which cell? It also isn't clear why you have =IF(LEFT(A2,1)="6","000000","000000") rather than just ="000000" You might also note that you don't need the ,1 in the LEFT functions; it defaults to ,1 if not otherwise spacified. -- David Biddulph GARY wrote: Currently, these formulas are in D1, E1, D2, E2, D3, E3, D4 and E4, respectively: =IF(LEFT(A1,1)="1",IF(LEFT(C1,1)="0",LEFT(C1,3)&MI D(C1,5,3),"000000")) =IF(LEFT(A1,1)="1",IF(LEFT(C1,1)="0","0000000","0" &LEFT(C1,2)&MID (C1,4,4))) =IF(LEFT(A2,1)="6","000000","000000") =IF(LEFT(A2,1)="6",IF(LEFT(C2,1)="0","0"&LEFT(C2,3 )&MID (C2,5,3),"0"&LEFT(C2,2)&MID(C2,4,4))) =IF(LEFT(A3,1)="1",IF(LEFT(C3,1)="0",LEFT(C3,3)&MI D(C3,5,3),"000000")) =IF(LEFT(A3,1)="1",IF(LEFT(C3,1)="0","0000000","0" &LEFT(C3,2)&MID (C3,4,4))) =IF(LEFT(A4,1)="6","000000","000000") =IF(LEFT(A4,1)="6",IF(LEFT(C4,1)="0","0"&LEFT(C4,3 )&MID (C4,5,3),"0"&LEFT(C4,2)&MID(4,4,4))) How can I create one formula by nesting each pair of formulas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting Formulas | Excel Worksheet Functions | |||
Nesting formulas | New Users to Excel | |||
nesting formulas | Excel Worksheet Functions | |||
nesting formulas | Excel Worksheet Functions | |||
Nesting Formulas | Excel Worksheet Functions |