Move column data based on last column

Question

I need to be able to move data from a group of columns (A,B,C) based on there being data in a fourth column (D) to a new group of columns (E,F,G).

A    B    C    D    E    F    G

20   0    0    15   15   0    0
0    10   0    5    0    5    0
0    0    90   90   0    0    90
0    0    0    0    0    0    0

When columns A, B and C are reported to have data and column D has data transfer the data from D to a corresponding column for A, B and C to be represented in columns E, F and G.

Answer 1

An if statement might work.

in column E: =if($D1=requiredvalue,$A1,0)

You didn't mention what the required value was to find in column D. If you mean a value above zero use $D1>0. If you mean one particular value use what I mentioned above.

Answer 2

If I understood your question correctly, use the following formula:

• E: =IF(AND($D1 > 0; $A1 > 0); $D1; 0)
• F: =IF(AND($D1 > 0; $B1 > 0); $D1; 0)
• G: =IF(AND($D1 > 0; $C1 > 0); $D1; 0)

Expand the formula from the first row to rows below.

The third argument to IF is the value of the cell in case where the condition is false. It could be any number or the value of a cell, for example $A1.