multiple arguments within a formula

  • Thread starter Thread starter GENO
  • Start date Start date
G

GENO

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???
 
You could simplify it tremendously via a vlookup, viz.:
=IF('Operational Mng Practices'!C16="","",VLOOKUP('Operational Mng
Practices'!C16,{1,"Foundational";2,"Fundamental";3,"Developing";4,"Mature";5,"WorldClass"},2,0))

Aloha? High-five it here, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
 
Hi,
=IF('Operational Mng Practices'!C16=1,"Foundational",IF('Operational Mng
Practices'!C16=2,"Fundamental",IF('Operational Mng
Practices'!C16=3,"Developing",IF('Operational Mng
Practices'!C16=4,"Mature",IF('Operational Mng Practices'!C16=5,"World
Class","Non-Compliant")))))
 
Hi,
=IF('Operational Mng Practices'!C16=1,"Foundational",IF('Operational Mng
Practices'!C16=2,"Fundamental,IF('Operational Mng
Practices'!C16=3,"Developing",IF('Operational Mng
Practices'!C16=4,"Mature",IF('Operational Mng
Practices'!C16=5,"WorldClass","Non-Compliant")))))
 
Back
Top