New Contributor

I need help making this formula true, 

basically I want it to say that if the "i" cell is equal to or greater then 0.6 to pull the "h" cell into "k" cell AND if "i" is equal to or less then -0.6 to pull "h" into k, I got it to work for positive numbers but cant seem to get it to work for my negative numbers, I have attached a picture

2 Replies
best response confirmed by milliemae (New Contributor)


See I need help writing a formula where you asked the same question. I posted a reply with a formula there.

whoops sorry, thought I deleted that! thank you that worked!!