while merging below two formula, i am getting error
IF(D4="Not Enabled","Not Enabled",IF(D4="NA","NA"))
=IF(AND(D4="Enabled",J4>0),"Reported",IF(AND(D4="Enabled",J4=0),"Not Reported"))
tried formula =IF(D4="Not Enabled","Not Enabled",IF(D4="NA","NA"),IF(AND(D4="Enabled",J4>0),"Reported",IF(AND(D4="Enabled",J4=0),"Not Reported","NA")))
Error: You have entered too many arguments for this function
Bookmarks