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
Bookmarks