Thread: OR statement VB
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default OR statement VB

That isn't providing a boolean True/False option (then
BLABLABLA) because it will always multiply by 20 (true*20=1) or(false*20=0).



Mike

"Bob Phillips" wrote:


"Mike H" wrote in message
...
if or(Sheets(1).Range("K36")16%, Sheets(1).Range("K37")16%) then
BLABLABLA


MsgBox val1 20 Or val2 0 then BLABLABLA without IF please?


val3 = -(val1 20 Or val2 0) * 20