Results 1 to 3 of 3

Thread: Excel question

  1. #1
    Goat Boy
    Join Date
    Jul 2003
    Location
    Alexandra Park, London
    Posts
    2,428
    Thanks
    0
    Thanked
    0 times in 0 posts

    Excel question

    Quick Q. I have an excel spreadsheet plotting cost over time. I have a graph with the time (seperated by month) as the X axis and cost as the Y axis. I want to figure out when the cost first crosses over the y=0 point, i.e. the point when the cost moves into the negative.

    Is this doable, or is it possible to do in the actual worksheet?
    "All our beliefs are being challenged now, and rightfully so, they're stupid." - Bill Hicks

  2. #2
    Senior Member
    Join Date
    Oct 2005
    Posts
    320
    Thanks
    3
    Thanked
    1 time in 1 post
    use the vlookup function on the spreadsheet, the final parameter will have to be true (unless there is a value exactly equal to 0) and they will have to be sorted, but i assume they are already like that.

    The cost will also have to be the left most column....

    so if cost is in a and time is in b:

    =vlookup(0,a:b,2,true)

    the first parameter states that you are looking for the value "0", second is the area of data you are looking at, 3rd the column you want to retrieve data from - in this case date

  3. #3
    Goat Boy
    Join Date
    Jul 2003
    Location
    Alexandra Park, London
    Posts
    2,428
    Thanks
    0
    Thanked
    0 times in 0 posts
    Many thanks mate. Just what I was after.
    "All our beliefs are being challenged now, and rightfully so, they're stupid." - Bill Hicks

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Quick Excel question?
    By Nick F in forum General Discussion
    Replies: 3
    Last Post: 16-09-2006, 08:58 PM
  2. Excel question - cut text from a cell
    By UKMuFFiN in forum Help! Quick Relief From Tech Headaches
    Replies: 2
    Last Post: 27-07-2006, 04:09 PM
  3. Quick Excel Question
    By muddyfox470 in forum Help! Quick Relief From Tech Headaches
    Replies: 4
    Last Post: 25-07-2006, 05:06 PM
  4. EXCEL question
    By robbiehall in forum Software
    Replies: 3
    Last Post: 07-01-2006, 10:54 PM
  5. Replies: 6
    Last Post: 12-08-2005, 08:50 AM

Posting Permissions

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