Something like:

=if(a1="home",b1-8,"what goes here instead")

And drag down your column.

dcjones wrote:

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

--

Dave Peterson