what formula do i put for column m = column k minus column l i

what formula do i put for column m = column k minus column l i

Post by amVubmlzc » Sat, 08 Jan 2005 01:45:04


no doesnt work i know the formula is correct its just that it is putting the
formula in cell M1 rather than the whole of column M
 
 
 

what formula do i put for column m = column k minus column l i

Post by Don Guille » Sat, 08 Jan 2005 02:12:01

if you want =e1-f1 in col M then do that. If you want e2-f2 then grab the
fill handle in cell m1 and copy down.

--
Don Guillett
SalesAid Software
XXXX@XXXXX.COM


the



all

 
 
 

what formula do i put for column m = column k minus column l i

Post by Gord Dibbe » Sat, 08 Jan 2005 05:18:22

jeniss

In M1 enter =K1-L1

Move the mouse pointer to the bottom right corner of M1.

You will see a black square lump.

Double-click on that lump to replicate the formula down as far as there is
data in column L.

=K1-L1 will be incremented to =K2-L2 and K3-L3 etc.

Gord Dibben Excel MVP

On Thu, 6 Jan 2005 08:45:04 -0800, "jenniss"