NEED HELP WRITING IF STATEMENT

[bumblebug]

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!!!!

 

[BT]

Hi there

This should work. =IF(H2="Platinum",170,IF(H2="Premium",150,50))

 

[Mike H]

Try this in I2

=IF(H2="Platinum",170,IF(H2="Premium",150,IF(H2="Alternate",50,"Not
Specified")))

Mike

 

[Max]

One way
In I2: =VLOOKUP(H2,{"Platinum",170;"Premium",150;"Alternate",50},2,0)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik

 

[BT]

Hi there

This should work. =IF(H2="Platinum",170,IF(H2="Premium",150,50))

Sorry - should have said to place in cell I2

 

[Gaurav]

in I2 enter the following

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

format I2 as currency.