Dear Friends,
I am working as MIS Analyst in a company where I received yearly sales report in I asked by my manager to tell the growth rate of sale based on yearly sales. Kindly help me knowing the exact formula or function required to solve this query.
In C3, enter the following:
=B3/B2-1
Drag down as required.
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
Hello,
This is my first post. Is there a way to calculate YOY Growth Rate with a twist to only include up September 2011?
I hope my attachment is attached.
Thank you in advance.
Please take a few minutes to read the forum rules, and then start your own thread.
Thanks.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks