need to find a percentage increase

Lady_J96

New Member
Joined
Nov 4, 2002
Messages
6
I am hung on a formula!! I need to find the percentage increase betweeb two years. Can anyone help me with the formula for figuring this out?
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
Hi - welcome to the board

=(thisyear - lastyear) / lastyear

format cell as %

paddy
 

Lady_J96

New Member
Joined
Nov 4, 2002
Messages
6
Hi, Paddy,
Thank you very ,much. I thought that was the answer.
Last years totals were $3,576,600 and this years totals were 3,822,650. My instucter keeps coming up with 3.3% which I don't find correct.
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
On 2002-11-05 22:30, Lady_J96 wrote:
Hi, Paddy,
Thank you very ,much. I thought that was the answer.
Last years totals were $3,576,600 and this years totals were 3,822,650. My instucter keeps coming up with 3.3% which I don't find correct.

3.3% ???
 

Lady_J96

New Member
Joined
Nov 4, 2002
Messages
6

ADVERTISEMENT

Yeah, that's why I am confused the dollar increase was $246,050 and I come up with 6.9%
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
as far as I can tell, you're right, the instructor's wrong. If you're paying the instructor for their services, don't :)

paddy
 

Lady_J96

New Member
Joined
Nov 4, 2002
Messages
6
Thank you very much. I am taking microcomputer applications in college and this is actually for a take home test and i was baffeled as to why I was coming up different, thank you for confirming the fact my instucter is wrong in his figures:)
 

NateO

Legend
Joined
Feb 17, 2002
Messages
9,700
On 2002-11-05 22:37, PaddyD wrote:
as far as I can tell, you're right, the instructor's wrong. If you're paying the instructor for their services, don't :)

paddy

Yep the prof.'s been smokin' his breakfeast. :biggrin:

The answer's definately something like:

0.068794385729

While this is resolved, the following works as well:

=LastYear/ThisYear-1


_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue"> Oliver</font></font></font>
This message was edited by NateO on 2002-11-05 22:56
 

Forum statistics

Threads
1,144,148
Messages
5,722,779
Members
422,457
Latest member
Mrmuskins

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top