Transfer amount into next column with condition?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top