IF STATEMENT HELP

D

dendh

I am trying to write if statement and havent been able to get all to work,
ex:
=IF(and(O18="L TO R",q18=Right hand")),"5500-402-02",IF(and(O18="R TO
L",q18="right hand")),"5500-401-02"
 
K

Kassie

=IF(AND(O18="L TO R",Q18="Right hand"),"5500-402-02",IF(AND(O18="R TO
L",Q18="right hand"),"5500-401-02"))
--
HTH

Kassie

Replace xxx with hotmail
 
Top