View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Amanda Amanda is offline
external usenet poster
 
Posts: 151
Default Formula for cashflow on every 90th item

hi,

I need a formula which will add together the total number of units (shown
monthly) and for every 90th unit put a cost of £250.

So, for example:

Month 1 2 3 4 5
Units 45 46 15 76 22
Cost £0 £250 £0 £250 £0

How can I do this without it showing £250 in every month???

Thanks

Amanda