Newbie Question

[PATRICIA LARUE]

What's wrong with this? IFS(B="","",B=<>"",D5)

[#2]

Try with semicolon instead of comma

[#3]

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