How do i calculate the percentage to compare two different years

F

Fred Smith

Please use this white space to elaborate on your question. You limit the
people who can respond to your question when you use only the subject line.

Do you want the percentage difference? If so, try:
A1: Last year's number
B1: This year's number
%diff: = (b1-a1)/a1
Format as percent

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

New computer, how do i move outlook 365 ENTIRELY? 0
I need to do a calculation based on the values in two cells 2
How do I calculate the date an employee will reach a specific age? 0
how do i calculate the number of days between two dates? 3
Formula to calculate the difference in weeks between two dates 3
Specify a column by the month to calculate it's data 6
How to calculate the difference between two different times. 1
How do I perform calculation within IF statement? 4

Top