Thread: If condition
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default If condition

This should do it

If Cells(Valid, 13) "" And Cells(Valid, 19) "" _
And Cells(Valid, 19) - Cells(Valid, 13) < 20 Then
Cells(Valid, 30) = Cells(Valid, 8) & cedissue
End If

Mike

"Rpettis31" wrote:

Is there a way to have this condition read in this one line.
IF cells(valid,13)"" and (cells(valid,19)""and
((cells(valid,19)-cells(valid,13))< 20 then
cells(valid,30)=cells(valid,8)&CEDissue

I am sure I am not following the correct syntax for the nested if but I am
having a hard time finding the correct syntax in this case.

Thanks