+ Reply to Thread
Results 1 to 2 of 2

Transfer amount into next column with condition?

  1. #1
    shital shah
    Guest

    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

    Shital

  2. #2
    Damon Longworth
    Guest

    Re: 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


    "shital shah" <shitalshah@discussions.microsoft.com> wrote in message
    news:31EB247A-CAFB-44D6-8B2A-566609035C91@microsoft.com...
    > 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




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1