Hi all!

Im new to this forum, so please forgive me if i posted in wrong section.

I have a problem, and ive been trying to find solution, but barely with any success (i am using Office 365ProPlus version).

- with my limited skills, i am trying to have one main column, which cell will gather data on multiple other columns cells and ,depending if those columns are blank, or have anything in cell, display text.

So, for example:

* Cell A1 will give 3 possible texts (Send to department1, Send to department2, Send to department3)
* Send to department1 will be displayed if B1 cell has anything, wont be displayed if cell is blank
* Send to department2 will be displayed if C1 cell has anything, wont be displayed if cell is blank
* Send to department2 will be displayed if D1 cell has anything, wont be displayed if cell is blank

* Text priority should be determinated to the right, so if both B1 and C1 cells have anything, then Send to department2 should be displayed while Send to department1 should be ignored...etc with further cells

So far, i am able to display one text depending on one cell, but i am not able to do this with multiple cells.

This is my current formula:

=IF(B1<>"";"Send to department1";"")

Please note that i use ;
My formulas are not working with ,

If any help or advice is given, i would really appreciate it. Thanks!