+ Reply to Thread
Results 1 to 2 of 2

function question

  1. #1
    x taol
    Guest

    function question

    fDate fa fb fDat1 fDat2 fStock
    2006-05-07 kk a 10 0 0
    2006-05-18 kk G283 6 0 6
    2006-05-14 kk a 9 0 9
    2006-05-18 mm G274 9 1 8
    2006-05-18 kk a 1 0 1
    2006-05-18 hh G278 1 0 1
    2006-05-18 pp m 2 0 2
    2006-05-18 aa x 5 2 3
    2006-05-19 mm G274 9 7 2

    i want to make fStock field using excel worksheet function in the upper
    data

    *** Sent via Developersdex http://www.developersdex.com ***

  2. #2
    JE McGimpsey
    Guest

    Re: function question

    One way:

    Assuming fStock is column F:

    F1: =D1-E1

    copy down.

    In article <#ZLjE3eqGHA.644@TK2MSFTNGP05.phx.gbl>,
    x taol <tomi3440@yahoo.com> wrote:

    > fDate fa fb fDat1 fDat2 fStock
    > 2006-05-07 kk a 10 0 0
    > 2006-05-18 kk G283 6 0 6
    > 2006-05-14 kk a 9 0 9
    > 2006-05-18 mm G274 9 1 8
    > 2006-05-18 kk a 1 0 1
    > 2006-05-18 hh G278 1 0 1
    > 2006-05-18 pp m 2 0 2
    > 2006-05-18 aa x 5 2 3
    > 2006-05-19 mm G274 9 7 2
    >
    > i want to make fStock field using excel worksheet function in the upper
    > data
    >
    > *** Sent via Developersdex http://www.developersdex.com ***


+ 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