I need help writing a formula

Copper Contributor

i want my formula to do the following 

IF "i" cell is equal to or greater then 0.6 or equal to or less then -0.6 pull "h" cell into "k" cell, below i have attached what it should end up looking like 

 

 

1 Reply

@milliemae 

In K2:

 

=IF(ABS(I2)>=0.6,H2,"")

 

Fill down.