Hi,
I am struggling with the number of embedded IF functions for what I am trying to achieve and would have assumed that there is a simpler way (there always is!)
Basically here is a summary of what I would like to achieve.
2 conditions, say A and B therefore 4 possible outcomes (AB, BA, AA, BB)
Based on the outcomes, I would like that to determine how I add 4 other cells, say A1, A2, A3, A4
IF AB, add A1,A2,A3
IF BA, add A1,A2,A4
IF AA, add A1,A2,A3,A4
IF BB, add A1,A2
How would i go about this?
Thanks.
Bookmarks