Problem with logical sentence

  • Thread starter Thread starter cecilia12345
  • Start date Start date
C

cecilia12345

i have this conditional sentence
If Cells(NumFilas, 2).Value <> "NAFF" Or Cells(NumFilas, 2).Value <
"NEQ" _
Or Cells(NumFilas, 2).Value <> "IBR" Then

.....

end if

however, the conditions are ignored when the program is running...
why
 
Cecilia,

I think you want ANDs instead of ORs. With ANDs, one of the <>
conditions will always be true, regardless of the value of
Cells(NumFilas,2).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Have you tried bracketing the equations? Might work..

eg.

If ((Cells(NumFilas, 2).Value <> "NAFF") Or (Cells(NumFilas, 2).Value <>
"NEQ") _
Or (Cells(NumFilas, 2).Value <> "IBR")) Then


John
 
I think you want ANDs instead of ORs. With ANDs, one of the <>

I meant With ANDs not ORs.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


Chip Pearson said:
Cecilia,

I think you want ANDs instead of ORs. With ANDs, one of the <>
conditions will always be true, regardless of the value of
Cells(NumFilas,2).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Click to expand...
 
-----Original Message-----
i have this conditional sentence
If Cells(NumFilas, 2).Value <> "NAFF" Or Cells(NumFilas,
Click to expand...
2).Value said:
"NEQ" _
Or Cells(NumFilas, 2).Value <> "IBR" Then

.....

end if

however, the conditions are ignored when the program is running...
why?
Click to expand...

Try sometihng like this



MyCheck = Cells(NumFilas, 2).Value <> "NAFF" Or Cells
(NumFilas, 2).Value <> "NEQ" _ Or Cells(NumFilas, 2).Value
<> "IBR"

If MyCheck = True then...
' ome
Else...
End If
 
At least two of the conditions will always be true. Change your OR to AND I
think.
 
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

Excel VBA 1
conditional format fails when copied 1
Excel Macro to automatically go to the right of the last colored cell 0
VBA set thick borders around non empty cells in range 0
Start Do/Loop within conditional statement 4
Conditional Formatting and VBA 4
Convert to Excel Macro 2
Loop don't work 1

Back
Top