Thread: Rest of the Year Calculation
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default Rest of the Year Calculation
Gfunc wrote:
I came up with this:

=IF(R2="August",S5*(12/8),(IF(R2="September",S5*(12/9),(IF(R2="October",S5*(12/10),(IF(R2="November",S5*(12/11),(IF(R2="December",S5*(12/12),(IF(R2="June",S5*(12/6),(IF(R2="July",S5*(12/7))))))))))))))

unfortunately I can only get 7 on there...

Gfunc


If you actually have the text names of the month in R2, use the following:

=S5*12/((((FIND(LEFT(R2,3),"JanFebMarAprMayJunJulAugSepOc tNovDec"))-1)/3)+1)
Reply With QuoteReply With Quote