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
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