I've got two columns of data. I'm trying to test if either cell has a value greater than 0 to return a output. Say, in this example "has dividend". My problem is with #NA cells. Is there a way to ignore null values?
I've also got some cells in the data that contain "#VALUE!". What is the basic difference between #VALUE and #NA?
Thanks for the help!
Bookmarks