View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
GENO GENO is offline
external usenet poster
 
Posts: 17
Default 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???