IF Then ElseIf Else Statement macro

[tonyk1051]

Hi,

Im having a tough time trying to set up a code for the intructions below, excel file is in attachment


need a code to do this
If coulmn S is yes
and column W says open box put in column H used, if coulmn W says
defective /unspecified or damaged then put in coulmn H
LR if value in column O is $20 or less, put Tradeport if value is between $20-$50
or put TL if value is over $50 BUT if column N has key word "cell phone" or "notebook" put in TT

thanks in advance