R
Raymond
I created a cell so that everytime I enter a text from some other cells, it
will add 1 to the value of the cell, otherwise, it won't add anything. If I
enter no text or a number in the other cells, this cell will display 0. The
formulas for the cell is like this: =SUM(IF(ISTEXT(D13:S13),1,0))
After entering text to three other cells, this cell will display a value of
3. However, I want that valued to be 1 less than. I cannot do this. If I
put minus 1 with an if statement, this cell will display a value of -1 when
no text is entered in other cells. Any folks have any idea how to fix this?
Thanks
will add 1 to the value of the cell, otherwise, it won't add anything. If I
enter no text or a number in the other cells, this cell will display 0. The
formulas for the cell is like this: =SUM(IF(ISTEXT(D13:S13),1,0))
After entering text to three other cells, this cell will display a value of
3. However, I want that valued to be 1 less than. I cannot do this. If I
put minus 1 with an if statement, this cell will display a value of -1 when
no text is entered in other cells. Any folks have any idea how to fix this?
Thanks