Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statement problem
Hi,
I'm trying to make up an IF statement but not having much luck, my table reads Date Area Tank 1/1/06 A Hp 1/1/06 B Lp 2/1/06 A Lp 2/1/06 B Shut 2/1/06 C LP 2/1/06 G Test I want to have in the formula cell a statement that returns four different numbers for the four possible text. i.e: If the data cell in tank reads "Hp" then the formula cell reads "1" or if the data cell reads "Lp" the formula cell reads "2" and so forth for all four options so that "Test"=3 and "Shut"=4 Is this possible? Many thanks, Ross |
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) |