Hi all,
I'm trying to devise a formula whereby the outcome in a cell is dependent on the inputs from 4 other cells. Not only that, but the outcome has 4 potential text values, i.e. the text in A5 (4 possible outcomes) is dependent on the inputs from A1 to A4. For example, if A1 and A2 are both Y, then the outcome is text 1, if A1 and A3 are Y, but A2 and A4 are N, then the outcome is text 2, and so on. Is this even possible and where do I start?
I'm not sure if I've given enough information, but wouold just like some pointers in the right direction.
Many thanks,
Paddy