I am embarrassed to ask such a simple question, but here goes. I want to set up a formula to check cells A1 through F1 and if all those cells are empty, leave the cell empty. but if any of those cells is not empty, to sum those entries and if the sum is zero to insert the test OK and if the sum of those entries is not zero, to insert the test Not OK. Here is my feudal attempt that did not work.
=IF(A1:F1)"","",IF(SUM(A1:F1)=0;"OK";"Not OK"))
Any help will be appreciated.
=IF(A1:F1)"","",IF(SUM(A1:F1)=0;"OK";"Not OK"))
Any help will be appreciated.