Reconciling Numbers on Excel

[sraiwal]

Hi there

I am looking to set up a formula where I can reconcile the numbers

I have attached a screenshot as an example

Here is what I am looking for:

When I enter a Number Into column N under "posted amount" I would like the following to happen :

- The payables cell to minus the number entered into column N
- The bank balance cell to minus the amount entered into Column N

Thank you.

 

[GlennUK]

Show what your expected result should be?