On Sep 1, 3:07*pm, 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

Drag and then press ctrl+F9