Percentage Increase

[DanielBellfield]

I need a formula to work out a percentage increase from one cell to another for example.

Cell A1 = 10
Cell A3 = 15
Cell A4 = 50%

Thanks in Advance!

 

[jaybee3]

Like this?

A4:
=(A3-A1)/A1

 

[njimack]

=(a2-a1)/a1
Or:
=A2/A1-1

 

[DanielBellfield]

Does it not need multipling by 100 then?

 

[DanielBellfield]

Does it not need multipling by 100 then?

Ah no doesnt matter...

Can i now add an if to that equation for example if over 5% fill cell red?

 

[jaybee3]

You can use conditional formatting for that.

 

[DanielBellfield]

You can use conditional formatting for that.

And how would i do that?

 

[jaybee3]

If you are on 2007

Highlight the cells you want to check if they are greater than 5%

On the Home Tab got to Styles. Click Conditional Formatting > Highlight cell rules > greater than.

Type in 0.05.

Click OK.

 

[DanielBellfield]

Thanks a lot!