Nested IF, AND, OR and NOT

bestjl

New member
Joined
Aug 14, 2014
Messages
3
Reaction score
0
Points
0
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:
 

Attachments

  • Excel Question.jpg
    Excel Question.jpg
    78 KB · Views: 16
I assume by "something" you mean >0?

If so,

Try: =IF(AND(B6>0,C6>0),B6+C6,IF(AND(D6>0,E6>0),D6+E6,IF(AND(B6>0,D6>0),B6+D6,IF(AND(C6>0,E6>0),C6+E6,0))))

Where first row of data is in B6:E6
 
This shows promise, but it won't ever have to do B+C or D+E.

The four possibilities I would like it to consider are:
If C and E are <0, then B+D
If C>0 and E<0, then C+D
If C<0 and E>0, then B+E
If C>0 and E>0, then C+E
 
I'm going to try and puzzle it out with that formula, subbing in the possiblities I want, thank you :)
 
Back
Top