In C1 enter this formula =A1-B1

With more detail perhaps something else could be devised.

Like what rows and how many cells and which column is adjacent?


Gord Dibben MS Excel MVP

On Sun, 16 Sep 2007 19:10:01 -0700, ron manring <ron
wrote:

when subtracting numbers in rows how do i get the answer to automatically
appear in the adjacent column?