Transfer amount into next column with condition?

[Guest]

Hi to all
I have data field for bank entry like

Tran Date, Description,Dr-Cr,Amt,Balance.

Now How can i transfer amt of Dr. and Cr. into next column.

What i want is if there is Dr. amt it should goto DR. Coulmn and if Cr. amt
it should goto Cr. cloumn.

I have inserted Dr. and Cr. column into worksheet.

Like

Tran Date, Description, Dr-Cr, Amt, Dr, Cr,Balance.

So if in Dr-Cr column if Dr. than that amount should move into Dr. Column
same for Cr amt also.

Any help.

Thanks

Shital

 

[Damon Longworth]

Try using an IF statement in your DR and CR columns. Something similar to:

=if(c5="DR",d5,0)
=if(c5="CR",d5,0)

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com