View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Claculating Annual Turnover forma Quarter

Errata: If your quarterly turnover is in A1, use:
=FV(A1,4,0,-1)-1

Fred

"Fred Smith" wrote in message
...
If you annual turnover is in A1, use:
=FV(A1,4,0,-1)-1

Regards,
Fred

"Caz H" wrote in message
...
Hi All
Does anyone know the formula to calculate the annual turnover rate based
on
a current quarterly percentage???

Thanks

Caz