Microsoft Windows xp professional w/serv...

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?

The Formula you want is: =IF(E1="paper",K1*J1-L1,"")

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(E2="paper",K2*J2-L2,"")

=IF(E3="paper",K3*J3-L3,"")

etc.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.

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History