in I2 enter the following

=IF(H2="Platinum",170,IF(H2="Premium",150,IF(H2="A lternate",50,"")))

format I2 as currency.


"bumblebug" wrote in message
...
Help! I need an IF statement that says the following:

If H2 = PLATINUM THEN I2=$170 OR IF H2 = PREMIUM THEN I2=$150 OR IF H2 =
ALTERNATE THEN I2=$50

Someone please help me!!!!