working out increases/decreases in excel

[gemmavine]

Hi

Can anyone help me please. I have a spreadsheet with prices

i.e. in column e + f

1.30 1.31
1.70 1.69

etc etc.

I want a formula to put in column g which shows whether it has increased or decreased using + and - figures.

i.e.

1.30 1.31 +0.01
1.70 1.69 -0.01

Thanks

Gemma

 

[VoG]

Try

=F1-E1

Edit: and format the result cell as Custom +0.00;-0.00

 

[gemmavine]

hi

how about if i want to put it as a percentage

ie. + 1%

etc

thanks

gemma

 

[VoG]

Try

=100*(F1-E1)/E1

 

[gemmavine]

hi

thats great thanks, it has worked. however, how do i get the percentages to round up/down?

and show with the percentage symbol next to them.

Regards

Gemma

 

[VoG]

Try

=(F1-E1)/E1

and format the cells as Custom +0.00%;-0.00%

 

[gemmavine]

Thank you soooo much

You're a star!

Gemma