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

IF AND
 

Try

=IF(J2="To",IF(AND(L2<"",N2<""),0.5,IF(OR(L2<"" ,N2<""),1,"L2 & N2 both
blank")),"J2 < TO")


"bob" wrote:

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