| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
3 level nested if has too many arguments ?
I don't see the error:
=if(left(C2,4),ur01,if(left(C2,4),ur02 ,if(left(C2,4) ,ur03, ""), ""), "") tia, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
3 level nested if has too many arguments ?
sorry I left out some parts, I'll repost.
"Janis" wrote: I don't see the error: =if(left(C2,4),ur01,if(left(C2,4),ur02 ,if(left(C2,4) ,ur03, ""), ""), "") tia, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
3 level nested if has too many arguments ?
Detail your situation.
maybe if left(c2,4)="uro1","what",if(next or =CHOOSE(MID(E2,4,1),5,6,7,8) -- Don Guillett Microsoft MVP Excel SalesAid Software "Janis" wrote in message ... I don't see the error: =if(left(C2,4),ur01,if(left(C2,4),ur02 ,if(left(C2,4) ,ur03, ""), ""), "") tia, |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
3 level nested if has too many arguments ?
I left out the quotation marks. Thanks!
"Don Guillett" wrote: Detail your situation. maybe if left(c2,4)="uro1","what",if(next or =CHOOSE(MID(E2,4,1),5,6,7,8) -- Don Guillett Microsoft MVP Excel SalesAid Software "Janis" wrote in message ... I don't see the error: =if(left(C2,4),ur01,if(left(C2,4),ur02 ,if(left(C2,4) ,ur03, ""), ""), "") tia, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 3 level nested if please explain | Excel Discussion (Misc queries) | |||
| Nested IF's with Logical Arguments - Doing something wrong here | Excel Discussion (Misc queries) | |||
| Nested IF's with Logical Arguments - Doing something wrong her | Excel Discussion (Misc queries) | |||
| I have run out of arguments for nested IF statement | Excel Discussion (Misc queries) | |||
| Limited IF Nested Level functions. | Excel Discussion (Misc queries) | |||
Linear Mode
