# Exact month to see when I break even

1. ## Exact month to see when I break even

Hi everyone,

I am trying to determine the exact month I will break even, given a set of revenue, discounts (cost) and the net revenue.

I can determine the first month my cashflow becomes positive with the formula:

=INDEX(\$B\$1:\$U\$1,MATCH(TRUE,\$B13:\$U13>0,0))

However, I want to know when my business become profitable considering accumulated costs in previous months.  Register To Reply

2. ## Re: Exact month to see when I break even

try below formula
=AGGREGATE(15,6,B1:U1/(SUBTOTAL(9,OFFSET(B13,,,1,COLUMN(B13:U13)-COLUMN(B13)+1))>=0),1)
Formula:  `Please Login or Register  to view this content.`  Register To Reply

3. ## Re: Exact month to see when I break even

Thank you samba_ravi, it worked perfectly.

Do you mind explaining your solution, I desire to understand what each function does Originally Posted by samba_ravi try below formula
=AGGREGATE(15,6,B1:U1/(SUBTOTAL(9,OFFSET(B13,,,1,COLUMN(B13:U13)-COLUMN(B13)+1))>=0),1)
Formula:  `Please Login or Register  to view this content.`  Register To Reply