IF only!

MattB · Mar 21st, 2002, 05:28 AM

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 · Mar 21st, 2002, 05:35 AM

Try

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

This will ignore the signs

MattB · Mar 21st, 2002, 05:42 AM

Thank you kindly!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 21st, 2002, 05:28 AM	#1
MattB Board Regular Join Date: Mar 2002 Posts: 62	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

Mar 21st, 2002, 05:35 AM	#2
RaoulF New Member Join Date: Mar 2002 Location: London, UK Posts: 17	Try =IF(ABS(H3)>0.1,"Investigate","Ignore") This will ignore the signs

Mar 21st, 2002, 05:42 AM	#3
MattB Board Regular Join Date: Mar 2002 Posts: 62	Thank you kindly!