Nested IF Statement?

[Deleted]

Help with a nested if statement?  Want the statement to be dependent on column D.  If column D is yes, and B or C is >  0 then amounts would move to new co in column G&H.  If column D is no and B or C is >  0, then amounts would stay with old co in columns E&F.

[#2 · Accepted solution]

Hello,

in cell E3 use

=IF(AND($D3="no",B3>0),B3,0)

copy across to cell F3 and then copy down. In cell G3 use

=IF(AND($D3="yes",B3>0),B3,0)

copy across to cell H3 and copy down.

[#3]

Awesome...Thank you!