Prev: Pivot Table Variance
Next: Looking up your previous questions
From: nat on 11 Mar 2010 15:37
How can i get the cell with my balance owed to subtract what payment I made
on the next cell?
--
nat
From: Toothsome Papa on 11 Mar 2010 17:14
let's say your balance owed is 100, and your payment was in cell B1, then you
would enter =100-A1 in the cell
If you tell us more about what you are trying to do, there are probably much
better ways to do this calculation.

"nat" wrote:

> How can i get the cell with my balance owed to subtract what payment I made
> on the next cell?
> --
> nat
From: Fred Smith on 11 Mar 2010 19:14
You subtract. If balance is in D2, and payment in C3, then new balance is:
=D2-C3

Regards,
Fred

"nat" <nat(a)discussions.microsoft.com> wrote in message
news:B524567B-7965-44EC-8635-126FC504461D(a)microsoft.com...
> How can i get the cell with my balance owed to subtract what payment I
> made
> on the next cell?
> --
> nat

 | 
Pages: 1
Prev: Pivot Table Variance
Next: Looking up your previous questions