| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Break even points
Is there a way to locate the breakeven point in a row of data and then return
a value from the same column where the breakeven point occurs? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Break even points
Example of data might help to understand what you mean by "breakeven point".
"Paul Bond" wrote: Is there a way to locate the breakeven point in a row of data and then return a value from the same column where the breakeven point occurs? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Break even points
A B C D E F G H I
J K 1 Number of people 2 4 6 8 10 12 14 16 18 20 2 Profit -10 -5 -2 1 3 5 10 15 25 40 I want to locate at which point the profit turns from -ve to +ve (cell E2) and then return the number of people (8, cell E1) Thanks "Toppers" wrote: Example of data might help to understand what you mean by "breakeven point". "Paul Bond" wrote: Is there a way to locate the breakeven point in a row of data and then return a value from the same column where the breakeven point occurs? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Break even points
try:
=INDEX(B1:K1,0,MATCH(TRUE,(B2:K20),0)) Entered with Ctrl+Shift+Enter HTH "Paul Bond" wrote: A B C D E F G H I J K 1 Number of people 2 4 6 8 10 12 14 16 18 20 2 Profit -10 -5 -2 1 3 5 10 15 25 40 I want to locate at which point the profit turns from -ve to +ve (cell E2) and then return the number of people (8, cell E1) Thanks "Toppers" wrote: Example of data might help to understand what you mean by "breakeven point". "Paul Bond" wrote: Is there a way to locate the breakeven point in a row of data and then return a value from the same column where the breakeven point occurs? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Interpolating between two points | Excel Discussion (Misc queries) | |||
| How do I find points on a curve between known points? | Excel Worksheet Functions | |||
| HELP!!!!!!!!!! Y By X Chart with points. | Charts and Charting in Excel | |||
| Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
| adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
Linear Mode
