Seige Silver wrote:
|| I have a worksheet with three columns. Col1 is item, Col2 is price
|| and Col3 is quantity. I need a column 4 that calculates col2 * col3
|| and displays total. I tried formulas, but i need the total to be
|| displayed automatically

What PRECISELY do you mean by "displayed automatically"? if you put a
formula in column 4 that says "Col2*col3 then it WILL display
"automatically.


|| whenever i navigate to that column after
|| entering col 2 and col 3. I dont want to drag the formula manually
|| to se the results.

And what do you mean "drag the formula manually"?
--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk