View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ross Ross is offline
external usenet poster
 
Posts: 152
Default 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