IF functions:select a whole column

[hineshm]

Hello

I was wondering if anybody could help me

I need an IF statement that can select a whole column and detect if it is equal to 1. If so then I need to output the result of column D. Is this possible?? I hope you understand what I mean.

Thanks

[crispbd]

The following if statement will check to see if the sum in a certain column is equal to 1, if so it outputs the value of the D column (the example looks in the a column)

=IF(SUM(A:A)=1,D2,"")


if you want a formula that you can fill down a column, and outputting column d:

=IF(A2=1,D2) when you fill this down the column the formula will update:

=IF(A3=1,D3)
=IF(A4=1,D4)