NEED HELP WRITING IF STATEMENT
 

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

NEED HELP WRITING IF STATEMENT
 

Hi there

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



"bumblebug" wrote:

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

NEED HELP WRITING IF STATEMENT
 

Try this in I2

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

Mike

"bumblebug" wrote:

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

NEED HELP WRITING IF STATEMENT
 

One way
In I2: =VLOOKUP(H2,{"Platinum",170;"Premium",150;"Alterna te",50},2,0)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---
"bumblebug" wrote:
.. 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

NEED HELP WRITING IF STATEMENT
 

"BT" wrote:

Hi there

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

Sorry - should have said to place in cell I2

"bumblebug" wrote:

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

NEED HELP WRITING IF STATEMENT
 

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