Maths expert please.

[bothered]

Math is not my strong point and I don't think this is too difficult, Well it is if you can't remember!
If I have a number say, 2456, then another number say, 2494, How do I find the percentage increase? I don't really need the answer but could somebody show me how to do it? Pref with an example or two so it sinks in.
Thanks.

[shwaip]

second number = 2494
first number = 2456

difference = second - first = 2494 - 2456 = 38

%difference = difference / first = 38 / 2494 * 100 = 1.5%

first = 10
second = 15

15 - 10 = 5
5/10 * 100 = 50% increase

[MrBill]

I'm NOT a math expert, but this is the formula I would use in Excel at work....

((1-(2456/2494))*100)

= 1.523656776 %

[bothered]

Excellent guys. I'll put one in excel and use the other method the rest of thr time.
Thanks a heap.

[MrBill]

Excellent guys. I'll put one in excel and use the other method the rest of the time.
Thanks a heap.
If the cell is formatted as "percentage", the formula would be different. No need for *100

=SUM(1-(2456/2494))

Obviously, you can replace 2456 & 2494 with cell numbers in the spreadsheet. ;)

=SUM(1-(B4/B8)) as an example.

[shwaip]

they're actually the same...one's just simplified from the other. Whichever is easier for you to remember.

[bothered]

Tried them both, because I'm always willing to learn and it's fun. They both work a treat. I wish I understood maths a little better.
Thanks again all.