Hi Greg,

Since Jessie is clearly dealing with currency calculations, it would not
seem appropriate to dim your variable as either long or integer.

Further, why would you advocate using the Int function?

---
Regards,
Norman



"GJones" wrote in message
...
Hi Jessie;

In VBA you can dim the value as an Interger or a Long, do
the math in memory and then write it to a cell. An
example might be

Sub try()

MyValue = Int(activecell) - 20
activecell = MyValue

End Sub

Thanks

Greg

-----Original Message-----
Hello,

Does anyone know how to create a formula that will allow
for a begining balance of $0.00 and then take away $20.00
to give you an ending balance of -$20.00. And then have
a begining balance of $-20.00 and take away $20.00 for a
total of -40.00 instead of $0.00. I keep getting a zero.
.