View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bill Sharpe Bill Sharpe is offline
external usenet poster
 
Posts: 348
Default How do I spread numbers over several months?

soconfused wrote:
I am trying to spread numbers over several months. For instance: If I have a
total of 160 hours to use I want 10% of that to go in a ship bucket. If the
hours total are less than 100 I want to spread the remaining over two months.


The following entries will work for what you stated, although what you
stated isn't exactly clear to me. I suspect you really want to subtract
out that 10% before calculating the two-month spread. If so, change A1
to B1 in the formulas for cells C1 and D1.

A1 contains your total hours entry
B1 will contain your "ship bucket" amount, whatever that means
C1 will contain the first month's hours total
D1 will contain the second month's hours total

B1 formula =A1*0.1
C1 and D1 formula =if(A1<100, 0.5*A1, 0)

Bill