View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hejnoid hejnoid is offline
external usenet poster
 
Posts: 2
Default Need help in showing future purchases over a period of time andat set intervals

Thanks for the help. You got me headed in the right direction. For
what it's worth I had to change the equation to:

=IF(AND(OR(A2=$I$3, AND(MOD(A2-$I$3,$I$2)=0, A2$I$3-1)), SUM($B$1:B1)<
$I$4), $I$4/$I$5,0)