Hi there,
I've been working on this for a couple hours now and I just can't seem to get it to work, if it's even possible. I'm trying to get a cell to return a sum based on 4 possible outcomes. There are 4 columns, and this is how my thinking needs to go:
If there's something in EST1 and EST2, add those.
If there's something in ADJ1 and ADJ2, add those.
If there's something in EST1 and ADJ2, add those.
If there's something in ADJ and EST2, add those.
I've gotten a single cell to accept two if statements, but there are 4 required (I think). Or some combination of IF, AND, OR and NOT.
I'm self-taught on this, so I'm sure I'm missing something! Any insight would be appreciated. It's driving me a bit:loco:
I've been working on this for a couple hours now and I just can't seem to get it to work, if it's even possible. I'm trying to get a cell to return a sum based on 4 possible outcomes. There are 4 columns, and this is how my thinking needs to go:
If there's something in EST1 and EST2, add those.
If there's something in ADJ1 and ADJ2, add those.
If there's something in EST1 and ADJ2, add those.
If there's something in ADJ and EST2, add those.
I've gotten a single cell to accept two if statements, but there are 4 required (I think). Or some combination of IF, AND, OR and NOT.
I'm self-taught on this, so I'm sure I'm missing something! Any insight would be appreciated. It's driving me a bit:loco: