Transfer amount into next column with condition?
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 ****al |
Transfer amount into next column with condition?
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 "****al shah" wrote in message ... 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 ****al |
All times are GMT +1. The time now is 08:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com