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
---
"GENO" wrote:
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???

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")))))

"GENO" wrote:

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???

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")))))


"GENO" wrote:

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???

Look in the help index for
CHOOSE

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"GENO" wrote in message
...
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???