View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Ryan Poth[_3_] Ryan Poth[_3_] is offline
external usenet poster
 
Posts: 3
Default Problem with logical sentence

Chip,
Want to try again? <bg
Ryan

-----Original Message-----
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" wrote in message
...
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


"cecilia12345" <cecilia12345.yjxtb@excelforum-

nospam.com wrote
in message news:cecilia12345.yjxtb@excelforum-

nospam.com...
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?


---
Message posted from http://www.ExcelForum.com/





.