I've been messing around with a spreadsheet for a while now and got it mostly working besides one part.
I have two columns, if a cell in the first column is "1", but the cell in the same row but different column is "empty" I want to output an error message.
I can do that for a single set of cells very easily with an IF, like so
=IF(J35 = 1,IF(ISBLANK(K35) = TRUE,"error","ok"),"ok")
But I have around 165 rows that I'd need to check that for.
Does anyone know how I could achieve this?
(The 1's and 0's are tickboxes in my actual table, ticked = 1, unticked = 0)