Since it's basically the same formula for all cells, you could just input it once and copy down as far as needed...

You could even add an IF test to hide the 0s that would otherwise appear until you actually input something into the adjacent cell.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]