breakeven

  1. L

    How to Calculate Breakeven Quantity through Formula

    Hi all, I'm having difficulty calculating breakeven quantity through an Excel formula and I was wondering if one of the genius can help me figure it out. Below are my costs: <colgroup><col><col></colgroup><tbody> Sales 9,000,000 Cogs 7,813,800 Direct Cost 896,139 Indirect Cost 617,916...
  2. T

    Finding First Positive Value in A row

    Hello everyone, To summarise: I am a quite expereinced excel user and usually end up fixing my problems but this time I have to ask online. Does anyone know how to use the following formula using different intervals along a single row? =MATCH(1,INDEX(1/($B51:$LM51>0),0),0) To...
  3. R

    VBA Goal Seek With If Statement (Want Result of Goal Seek to be a Minimum of 0")

    I have the following VBA code, but I want to limit O22 at 0 because this is a breakeven analysis with multiple revenue-drivers. The idea is that if O22 is 0, then this is sufficient information. Those using the spreadsheet do not need to know that O22 can be "(999,999,999)" and still...
  4. N

    How to automatically label data point at intersection of plot?

    Hey Everyone! I currently have a loop running in VBA that requires inputs from a user, and then provides data and a plot. Essentially this is a break even function. The plot consists of 3 horizontal lines (will be the same in every plot) , and a linear function (changes based on user input). I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top