Hi All,

I am trying to create an if statement that has 15 values. If none of those values are true, the cell would have a space (" ") in it. If one is true, it would equal a value of 1-15 and the others would be false. This is the best I could come up with and now I am asking for your help.

=IF(AR!J4 = "Add",1," ",IF(AR!J4 = "Update/Display",2, " ",IF(AR!J4 = "Add Update/Display",3, " ",IF(AR!J4 = "Update/Display All",4, " ",IF(AR!J4 = "Add Update/Display All",5, " ",IF(AR!J4 = "Update/Display Update/Display All",6, " ",IF(AR!J4 = "Add Update/Display Update/Display All",7, " ",IF(AR!J4 = "Correction",8, " ",IF(AR!J4 = "Add Correction",9, " ",IF(AR!J4 = "Update/Display Correction",10, " ",IF(AR!J4 = "Add Update/Display Correction",11, " ",IF(AR!J4 = "Update/Display All Correction",12, " ",IF(AR!J4 = "Update/Display Update/Display All Correction",14, " ",IF(AR!J4 = "Add Update/Display Update/Display All Correction",15, " "))))))))))))))

The error I get with this is "Too many Arguments with this Function"

Thanks for your help