How can I link data in three different cells? ck# date amount

S

Shiela

I am trying to balance a checking account in excel. I want to keep three
cells linked to one another, for example check #, Date, and amount from a
registery and then link the comparison to the banks check # while leaving
those three information linked together. For example Banks cleared date,
cleared amount, and cleared check number. I also want the register to adjust
information to match to the bank statement and show a difference between the
two amounts into a new cell.
 
T

Thomas Roos

This might get you started
Ck # Date Amount String
1234 12/31/2008 100.00 1234 12/31/08 100.00

the string formula is
=A2&" "&TEXT(B2,"mm/dd/yy")&" "&TEXT(C2,"##0.00")
 
T

Thomas Roos

This might get you started
Ck # Date Amount String
1234 12/31/2008 100.00 1234 12/31/08 100.00


the string formula
=A2&" "&TEXT(B2,"mm/dd/yy")&" "&TEXT(C2,"##0.00")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top