Re: Excel Question
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.
|