Autofill IF Formula

Microsoft Windows xp professional w/serv...
April 1, 2010 at 15:10:58
Specs: Windows XP
Can I create a formula for the whole column so I wouldn't have to keep pasting the formula as more information is added daily?
2.what formula command is best?
IF(E1="paper",k1*j1-L1) if E1 doesn't ="paper" leave blank.
Information is added daily. Is E1,K1,J1,L1 what I should put or is there a code/function that should be inplace of the 1's to represent the whole column as it grows?

See More: Autofill IF Formula

Report •

April 1, 2010 at 18:10:15
The Formula you want is:


You could simply drag this down as far as you want and the 1's will increment 1 row at a time as you drag it down.


If you don't want the formulae just hanging around doing nothing until you add data, you could use a VBA WorksheetChange macro that would place the formula in the cell after you add data to the bottom of column E.

If you are interested in that option, let us know. We'd need to know a few more details, such as where the formula needs to go, etc.

Report •
Related Solutions

Ask Question