Sep 20 2017
04:00 PM
- last edited on
Jul 25 2018
10:05 AM
by
TechCommunityAP
Sep 20 2017
04:00 PM
- last edited on
Jul 25 2018
10:05 AM
by
TechCommunityAP
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.
Sep 20 2017 07:30 PM
SolutionHello,
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.
Sep 20 2017 07:30 PM
SolutionHello,
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.