Something like this, assuming quantity in column A and price in column C?
=if(isblank(a2),"",a2*c2)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"cwool4512" wrote in message
...
Can Excel recognize when data is entered into a cell and then apply the
appropriate formulas from the cells above? I have a spreadsheet set up
for
people to use but some of the cells are locked and I don't want to print
the
whole worksheet until info is entered into cells and then the formulas be
applied.