Condition formatting.

Hello,

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.

Thank you.

By: Deepak Hatkar

Leave a Reply

Your email address will not be published. Required fields are marked *