Heidi

L and K are columns, not "lines".

To subtract K1 from L1 enter in M1 =L1-K1

To subtract a range in one formula.......

=L1:L100-K1:K100 entered in M1


Gord Dibben Excel MVP

On Tue, 3 May 2005 11:42:07 -0700, "Heidi"
wrote:

How do I subtract line k from line L in excel?