Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Writing IF Statement | Excel Worksheet Functions | |||
Statement writing problem | Excel Worksheet Functions | |||
writing a statement | Excel Worksheet Functions | |||
Help writing an IF statement | Excel Worksheet Functions | |||
when writing an IF statement what is the syntax for "Not Equal to. | Excel Discussion (Misc queries) |