IF only!

[MattB]

Folks

I have 30,000 codes running down column H, some positive, some negative.
In column I I would like to say either Investigate if the figure is greater than 0.1 or less than minus 0.1, ignore otherwise.
Now I have no probs if I just want to say IF(H3>0.1,"investigate","ignore") so how do I work it for my problem?
Please excuse my ignorance
Matt

 

[RaoulF]

Try

=IF(ABS(H3)>0.1,"Investigate","Ignore")

This will ignore the signs

 

[MattB]

Thank you kindly!