Friday, January 3, 2014

Growth Formula

The Growth formula is used to forecast predicted growth in for example a business's projected sales figures.
Theory:
=Growth(previous sales data range, previous month numbers data range, new month number or cell reference)
Example:
=Growth($B$2:$B$13,$A$2:$A$12,C2)
For the formula above make sure you use absolute cell referencing with the dollars on both sides of the letters as shown, a part from the last cell reference being "C2" in this case. Then fill the formula down.
OR
=Growth($B$2:$B$13,$A$2:$A$12,13)
For the formula above make sure you use absolute cell referencing with the dollars on both sides of the letters as shown, a part from the last part which is just a number in this case "13". This paticular formula using the number 13 and not a cell reference is only useful for single next month prediction.

1 comments:

kahlilpablo said...

The History of Poker | News, Events and Facts
Poker is 원 엑스 벳 played with eight cards and eight cards, the player to the left and the dealer to the right. This 커뮤니티 사이트 is the only 아트그라비아 장주님 game where the 크롬 사이트 번역 player 안전한 바카라 사이트 who dealt two cards was in

Post a Comment

www.cineclouds.com. Powered by Blogger.