| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=IF problem
HELP! as a sort of beginner finaly using the =IF command and is working fine. BUT.....i try to add some more if commands in one line but it doesn't work: =IF(A3="Default Template Windows 2003 Member Server","DEFAULT-YES",IF(A3="Default Template Windows 2000 Domain Controller","DEFAULT-YES",IF(A3="Default Template Windows 2003 Domain Controller","DEFAULT-YES",IF(A3="Default Template Windows 2000 Member Server","DEFAULT-YES",IF(A3="Default Template Windows 2000 Cluster Server","DEFAULT-YES",IF(A3="Default Template Windows 2003 Cluster Server","DEFAULT-YES",IF(A3="Default Template Windows 2000 Member Server IIS","DEFAULT-YES",IF(A3="Custom","NO")))))))) Does anyone know what the problem can be or another solution? Is there a maximum of characters or something? Thanks in advanced! Edo -- EdoZwart ------------------------------------------------------------------------ EdoZwart's Profile: http://www.excelforum.com/member.php...o&userid=30000 View this thread: http://www.excelforum.com/showthread...hreadid=497646 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| have some problem with database | Excel Discussion (Misc queries) | |||
| Urgent Help Required on Excel Macro Problem | 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
