| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF: Argument problem
I am aware that the max # of (IF) arguments is 8. the following formula use
all 8 but when i try and add another function to it i get an error message. =IF($O$7="1552.52 / 1530.33",CONCATENATE(tx52type," ",tx52a1),IF($O$7="1549.32 / 1536.61",CONCATENATE(tx49type," ",tx49a1),IF($O$7="1555.75 / 1533.47",CONCATENATE(tx55type," ",tx55a1),IF($O$7="1558.98 / 1538.19",CONCATENATE(tx58type," ",tx58a1),IF($O$7="1550.92 / 1528.77",CONCATENATE(tx50type," ",tx50a1),IF($O$7="1554.13 / 1531.90",CONCATENATE(tx54type," ",tx54a1),IF($O$7="1558.17 / 1538.98",CONCATENATE(tx58.17type," ",tx58aa1),IF($O$7="1547.72 / 1539.77",tx47type,W7)))))))) I would like to add one more concatenate statment to the last if statement but it will not allow me to. WHY? here is what i need it to say when i am done. =IF($O$7="1552.52 / 1530.33",CONCATENATE(tx52type," ",tx52a1),IF($O$7="1549.32 / 1536.61",CONCATENATE(tx49type," ",tx49a1),IF($O$7="1555.75 / 1533.47",CONCATENATE(tx55type," ",tx55a1),IF($O$7="1558.98 / 1538.19",CONCATENATE(tx58type," ",tx58a1),IF($O$7="1550.92 / 1528.77",CONCATENATE(tx50type," ",tx50a1),IF($O$7="1554.13 / 1531.90",CONCATENATE(tx54type," ",tx54a1),IF($O$7="1558.17 / 1538.98",CONCATENATE(tx58.17type," ",tx58aa1),IF($O$7="1547.72 / 1539.77",CONCATENATE(tx58.17type," ",tx58aa1),W7)))))))) Sorry for the short cell id's but i had to do this so i would not reach excel's max char lenght. David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text argument in vlook up which has a "" | Excel Worksheet Functions | |||
| read in Vlookup an argument that has quotations(") | Excel Discussion (Misc queries) | |||
| Problem With Reference Update | Excel Worksheet Functions | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Threaded Mode
