IF STATEMENT HELP

  • Thread starter Thread starter dendh
  • Start date Start date
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"
 
=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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If/Then statements in Visual Basic 6
Adding NonBlank Cells 3
first record query 1
Assign points based on two conditions 1
how many inbedded if statements can i have? 5
multiplying a negative time value by a monetary rate 1
Windows XP Regedit and taskmanager will not stay open 3
Sorting by number of laps and completion time. Taking out DNF's. 1

Back
Top