I need a solution in spreadsheet. I am trying to join a couple of cells in WPS Spreadsheets with an IF statement. For eg. IF value in cells K11:K2000 is greater 0 then add 1 in cell H1. Similarly, IF value in cells K11:K2000 is less than 0 (negative value) then add 1 in cell H2.
I have attaced an image of the same as well.
By: Deepak Hatkar