Hello there,

I need a formula, I assume using IF as a basis, that enables me to have more than one logical test and display a specific piece of text in the cell if each one is true.

For example:

If A1=1, display London, if A2=1, display Paris, if A3=1 display Berlin. But here's the catch - if A1 and A2 both contain 1 then I want "London, Paris" displayed in the cell, and if A1 and A3 both contain 1 then I want "London, Berlin" in the cell.

Any help would be greatly appreciated, and in practise there are many more than three cells but that's just as an example.

Thanks,

Daniel