Thread: IF AND
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default IF AND

If J2 = "to"

AND

If L2 = any alpha value and N2 = a blank cell (empty), then Y2 = 1

OR

If L2 = a blank cell (empty) and N2 = any alpha value, then Y2 = 1

OR

If L2 = any alpha value and N2 = any alpha value, then Y2 = 0.5


Can anyone kindly provide a formula for this? Thanks.

Bob