View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
BT[_2_] BT[_2_] is offline
external usenet poster
 
Posts: 22
Default 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!!!!