Forum Discussion

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor

    Hi Patricia,

     

    The cell references in your formula aren't complete, you cannot use only B, have to determine the number of the row as well, for example, B1, B2, B10 etc.

     

    The second mistake is in the logical operators, you cannot use two of them in a single comparison like this: B1=<>"", you have to decide either equal to or not equal to.

     

    Regards

Resources