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
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. It should be like pure
forms. Any advice?