| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statement problem
Assuming Data Are and Tank are columns A B and C isnt this just a simple case of in column D entering the formula =IF(B1="Hp",1,IF(B1="Lp",2,IF(B1=Shut",3,IF(B1="Te st",4,"UNKNOWN")))) Then copy the formula down the D column (Im sure theres a simpler formula to use to produce this) -- Special-K ------------------------------------------------------------------------ Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470 View this thread: http://www.excelforum.com/showthread...hreadid=561109 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF statement problem
That seems the right way, also could use a vlookup function and another table
"Special-K" wrote: Assuming Data Are and Tank are columns A B and C isnt this just a simple case of in column D entering the formula =IF(B1="Hp",1,IF(B1="Lp",2,IF(B1=Shut",3,IF(B1="Te st",4,"UNKNOWN")))) Then copy the formula down the D column (Im sure theres a simpler formula to use to produce this) -- Special-K ------------------------------------------------------------------------ Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470 View this thread: http://www.excelforum.com/showthread...hreadid=561109 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I'm having a really strange problem with 3 if statements. | Excel Worksheet Functions | |||
| If Statement linked to cell with VLOOKUP problem - getting wrong v | Excel Worksheet Functions | |||
| Fundamental problem with IF statement | Excel Worksheet Functions | |||
| Formula Problem - If Statement | Excel Worksheet Functions | |||
| Excel Display Problem | Excel Discussion (Misc queries) | |||
Hybrid Mode
