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.
.