Dear all,

I need help on the following problem urgently:

In my worsheet:

Cell(K,38) = 2
Cell(C,107) = 0.8
Cell(C,108) = 280000

In Cell(K,108), I have a formula:
K38*$C108*$C$107

The the value of Cell(K,108) is 448000

Now I have the change the formula on Cell(K,108). It
should reference to it's cell to the left, i.e. Cell
(J,108). If Cell(J,108)=0, then I have to multiply the
original formula by 0.5, i.e. (K38*$C108*$C$107) * 0.5,
otherwise, it keeps the original formula K38*$C108*$C$107.
But the cells doesn't come out with the result, it
displays the formula instead: "=IF
(J108=0,"K38*$C108*$C$107","0.5*(K38*$C108*$C$107) ")"

Why does this happen? Can anyone help? Thanks in advance!!

Terence