| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statement problem | New Users to Excel | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| IF Statement | New Users to Excel | |||
| 7+ nested if statement? | Excel Worksheet Functions | |||
Threaded Mode
