How To Find Percentage Difference Between This Quarter's Sales From Last Year's Sales

**joechung** · 02-08-2020, 08:15 PM

Hello,

I am seeking help to write a formula that will help me calculate the percentage difference from 2020 Q1 sales to 2019 Q1 sales. Essentially I want to know if I made more in this year's quarter, how much more did I make? 10% more? 20%? I hope I asked my question correctly.

Thanks in advance,
Joe

**6StringJazzer** · 02-08-2020, 10:32 PM

Assume 2020 Q1 is in cell B1 and 2019 Q1 sales is in A1. Percentage difference formula is

Formula:

Please Login or Register  to view this content.

Set the format for the cell to be "%".

How To Find Percentage Difference Between This Quarter's Sales From Last Year's Sales

LinkBack

Thread Tools

Rate This Thread

Display

How To Find Percentage Difference Between This Quarter's Sales From Last Year's Sales

Re: How To Find Percentage Difference Between This Quarter's Sales From Last Year's Sales

Thread Information

Users Browsing this Thread

Similar Threads

SALES COMPARISON BY WEEK NUMBER, MONTH, QUARTER AND yEAR

Whats the formula to find percentage of sales thats already given?

Arranging year-over-year 3rd quarter sales with all customers listed in only one column.

Formula to find sales for fixed event at a certain sales date

Each Item Sales contribution in Total Sales percentage wise and Chart or Graph

[SOLVED] Formula to find totals by Quarter from monthly sales

Pivot Table - Compare Current Year Sales To Previous Year Sales

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions