percentage comparisons

[fenster]

Hi folks,

Im working on a comparison on figures from 2004 compared to 2003 figures

example
2003 figure 15182.39 cell 2003!d7
2004 figure 20857.12 cell 2004!d7

difference 5674.73

and was wondering if any of u could help..

how can I show the 5674.73 as a percentage?
Can I make the percentage red if in minus? (if figure is in minus)
As I don’t have many figures for 2004 is there a way to get the formula to ignore if both figures are not greater than 0.00 or one of the cells is empty.

Thanks as always..

Davie.

 

[fenster]

Re: percentage comparisons (RESOLVED!)

sorry mark , was away doin the sheet - and realised just to remove the percentage part..

thanks ever so much for ur input as the sheet is working great.
the percentages , cells r blank until the formula has the figures needed to compare - its looking really good.

what can i say!



fenster .

 

[mark007]

No problem