number of periods function where payments(inflows) are not equal

  • Thread starter Thread starter epcookjr
  • Start date Start date
E

epcookjr

i am looking for a function that returns the number of periods when the
period payments are not equal. such as calculating pay back on and investment
where the inflows are not equal.
 
If you have a set of values in A1 thru A10 and want the number that are not
equal:

=SUMPRODUCT(--((A1:A10)<>MODE(A1:A10)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IRR or NPV 3
IRR, with cash flows in non-adjacent cells 6
IRR Logic 2
Constant loan payments vs. constant payments of principal 2
How do I calculate a payment? 7
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
calculating inflows in each month depending on different paymentterms 1
Loan Principal Payments 1

Back
Top