I need help writing a formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2223830%22%20slang%3D%22en-US%22%3EI%20need%20help%20writing%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2223830%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20want%20my%20formula%20to%20do%20the%20following%26nbsp%3B%3C%2FP%3E%3CP%3EIF%20%22i%22%20cell%20is%20equal%20to%20or%20greater%20then%200.6%20or%20equal%20to%20or%20less%20then%20-0.6%20pull%20%22h%22%20cell%20into%20%22k%22%20cell%2C%20below%20i%20have%20attached%20what%20it%20should%20end%20up%20looking%20like%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2223830%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New 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.