IF B="" and A="Large" THEN "Large"
B="Large" then Large
have you tried
if [column B] = 'Large' Then 'Large'
elseif isnull([column B]) and [Column A] = 'Large' then 'Large'
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thank you everyone for your suggestions. I tried Jim's first and it works.