Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |