Forum Discussion
PATRICIA LARUE
Jun 06, 2018Copper Contributor
Newbie Question
What's wrong with this? IFS(B="","",B=<>"",D5)
- e-aldoIron Contributor
Try with semicolon instead of comma
- Haytham AmairahSilver 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