View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
l[_2_] l[_2_] is offline
external usenet poster
 
Posts: 6
Default generating random cash flow with same IRR

Hi all

is there a way i can ask excel to change the amounts received in
several years, but keeping the IRR always the same? is a variation of
Goal seek i imagine.

More in general, can Excel generate several numbers keeping the Sum
constant?
thanks