I need help with some calculation that I am trying to achieve.
I want to create a macros or formula that will allow me to check a row of a table for values greater than 0:
Within a row, if for all cells (that contained a number) are larger than VALUE OF 0 then output 1.
Any help will be helpful!
I have attached an excel file for better depiction of what I would like the result column to look like
thanks!
Bookmarks