Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calulate amount based on multi condition | Excel Discussion (Misc queries) | |||
transfer stock on condition | Excel Worksheet Functions | |||
add numbers in a column and transfer result to another column | Excel Worksheet Functions | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) |