Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
multiple arguments within a formula
I need advice regarding a formula, I'm trying to use multiple arguments for
an 'if' statement for a selection of rows. =IF('Operational Mng Practices'!C16=1,"Foundational","Non-Compliant",IF('Operational Mng Practices'!C16=2,"Fundamental","Non-Compliant",IF('Operational Mng Practices'!C16,"Developing","Non-Compliant",IF('Operational Mng Practices'!C16=4,"Mature","Non-Compliant",IF('Operational Mng Practices'!C16=5,"WorldClass","Non-Compliant"))))) anyone with advices??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If, multiple arguments | Excel Discussion (Misc queries) | |||
Formula with multiple arguments? | Excel Worksheet Functions | |||
Multiple Arguments | Excel Discussion (Misc queries) | |||
sum with multiple arguments | Excel Worksheet Functions | |||
Multiple Arguments | Excel Worksheet Functions |