TooManyArguments.JPG
I have tried creating a formula testing to see if three cells are not empty. If they are not empty I want a value of "1" to be returned, if not then I want to test to see if the three cells are all blank. If all three cells are blank then I want a value of "*" returned. And all else should return "0".
Excel refused my formula saying there were too many arguments. Is there a better way to write the formula or a better set of functions?
Bookmarks