Hi

I have created the following if function which works well.

=(IF(C14="SALARIED",$D$2,IF(C14="JH",$D$3,IF(C14="KH",$D$4,IF(C14="CS 3",$D$5,IF(C14="SH AM",$D$6,IF(C14="AJ MON",$D$7,IF(C14="AJ OTHE",$D$8,IF(C14="AJ WED",$D$9,"")))))))))

I now want to add another condition at the end as follows but I get the error message shown underneath the formula: -

=(IF(C14="SALARIED",$D$2,IF(C14="JH",$D$3,IF(C14="KH",$D$4,IF(C14="CS 3",$D$5,IF(C14="SH AM",$D$6,IF(C14="AJ MON",$D$7,IF(C14="AJ OTHE",$D$8,IF(C14="AJ WED",$D$9,if(C14="HP 2",$D$10,""))))))))

"The specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format"

Why do I get this message? I'd appreciate anybodies help on this.

Many thanks