gerald

Perhaps 280,000 0r 2000 are Text and not numerics.

Quick check.......

In A2 enter =ISNUMBER(A1) will return TRUE or FALSE

Same for C1

If FALSE, copy an empty cell formatted to General and select your numbers then
Paste SpecialAdd)KEsc.

Gord Dibben Excel MVP

On Sun, 7 Nov 2004 09:52:01 -0800, "
wrote:

A1=($280,000)
B1=(=A1*0.05/12)
C1=($2000)
D1=(=A1+B1-C1)