Thread: number of periods function where payments(inflows) are not equal
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default number of periods function where payments(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)))

--
Gary''s Student - gsnu200846


"epcookjr" wrote:

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.
Reply With QuoteReply With Quote