[Solved] need help with IF conditions
Posted: Thu Jan 16, 2020 3:32 pm
Hey, i'm pretty new to OpenOffice Calc.
I made a list to keep track of the anime series i've watched so far and i want to add a cell that counts how many shows i haven't finished yet. But if i use the COUNTIF method to check whether the cells in the E-column are empty, then it also counts all the empty cells farther down the list where i haven't input any shows as of yet. So i wanted to to check if the C-cell is not empty and if so check, if the corresponding E-cell is empty. How do i code this?
I made a list to keep track of the anime series i've watched so far and i want to add a cell that counts how many shows i haven't finished yet. But if i use the COUNTIF method to check whether the cells in the E-column are empty, then it also counts all the empty cells farther down the list where i haven't input any shows as of yet. So i wanted to to check if the C-cell is not empty and if so check, if the corresponding E-cell is empty. How do i code this?