[Dynasty]

An intermediary step should do the job.

Basically, in collumn L, write a forumula which says "If K=Yes, then L=0; If K=No, then L=J.

Then use your original forumula in the new collumn L.

If this hurts the visual presentation, then just hide collumn L.