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
Bookmarks