Hi All,

I am not to good with excel but I am learning fast.

Problem, I have a worksheet, on the sheet there are 3 col's.

Col1 could contain the word "home"
Col2 contains mileage.

What I want to do is:-

If COL1 contains the word "home" then COL2 contains the amount of miles
LESS 8 miles.

Can anyone point me in the right direction to create a formula,

Many thanks in advance.

Happy new year to you all at 24:00 01/01/05-06

Regards

Dereck


--
dcjones
------------------------------------------------------------------------
dcjones's Profile: http://www.excelforum.com/member.php...o&userid=29941
View this thread: http://www.excelforum.com/showthread...hreadid=496415