Results 1 to 2 of 2

Breakeven function with TOTALs moving depending where the breakeven cost and quantity fall

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-15-2012
    Location
    las vegas
    MS-Off Ver
    excel 2007
    Posts
    147

    Breakeven function with TOTALs moving depending where the breakeven cost and quantity fall

    Hey guys,

    I'm trying to figure out a way that I can get the breakeven cost and quantity, given the initial cost. Please see the picture.

    Here's how I wish for it to look like. When the initial cost is 30,000 the breakeven is at C. When the IC is at 55,000, the Beven is at E. What i mean is the calculation is moving depending on where the breakeven falls. Please also note that there's a C and D under the the breakeven totals to indicate which letter the breakeven is made/realized/reached. Also, I need to have the word "TOTAL" to follow the point where the breakeven totals are.

    In addition, I did some calculation on cells C11 and C12, and D24 and D25. I did this to get the remainder amount and get the initial cost and the total (to the right of the initial cost).

    Everything seems complicated to me and don't know what functions or even where to begin.

    Please help.
    Thanks in advance.
    Attached Files Attached Files
    Last edited by managingcrap; 05-29-2014 at 08:09 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Breakeven chart - won't start at zero
    By Doogle in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 01-14-2007, 06:37 AM
  2. Breakeven Chart
    By David Hallam in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-04-2007, 06:31 PM
  3. breakeven formulas
    By Runner77 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-06-2006, 02:15 AM
  4. [SOLVED] breakeven analysis chart
    By Paige in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-12-2005, 08:05 AM
  5. Breakeven Chart
    By Alan P in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-03-2005, 10:05 AM

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