View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Trouble in Dragging the cell

Tools Options Calculation Automatic
--
Gary''s Student - gsnu200802


"Tim Leung" wrote:

When I tried to drag the formula of the cell to another cell, the amount
supposed to be calculated on another celll did not worked. The Original
amount from the original cell appears on another cell.

Also, when I tried to do the formula by myself insteading of dragging, the
cell shows "0". I have checked the cell and the format is number.
Unfortunately, it still shows "0".

Appreciate any help.
--
Tim