03-12-2019 10:05 AM
03-12-2019 10:37 AM
With that function you compare each cell of your range with the text in second parameter. I guess no such texts in the range, result shall be zero.
You may use
if there are no blank cells in row 6.
03-12-2019 10:51 AM
What I am trying to do with the function is compare efficiencies by day. If the production line produces 95% or high of the plan I want it to count 1. Attached is a basic example of my spreadsheet. The spreadsheet is very large and adding extra rows is extremely time consuming and difficult due to the other sheets linked to this sheet. If actual production hasn't happened yet then the cell will read "" not blank also.
03-26-2019 09:36 AM
Unfortunately this didn't work either. Row 4 contains an if formula that reads another sheet. The if formula returns " " if the cell in the other sheet is blank (if(isblank(Sheet1!A4),"",Sheet1!A4) for example. That is what is making this so difficult. @Sergei Baklan
by vwinston on June 02, 2020
by Alan Skelly on June 01, 2020
by Prash Shirolkar on September 25, 2018
by Johnnie Thomas on May 10, 2018