Percentage Formula

[J.B.]

I am building a budget presentation for a yearly activity
to present to the respective boards. I am listing the
2003 budget figures in column H and the 2004 figures in
column F. I would like to hace the percentage increase or
decrease over previous previous year in column J. Can
anyone give me a formula to accomplish this. This Budget
consists of over 300 lines, but budget figures only use
maybe 150 lines. The rest are title lines and etc so the
formula would almost require entering on each line or by
board groups. I think I prefer individual lines.
Thanks for any help offered.. JB

 

[Frank Kabel]

Hi
enter the following in J1
=F1/H1-1
format as percentagee and copy down

or if you want to check for text entries, try
=IF(AND(ISNUMBER(F1),ISNUMBER(H1)),F1/H1-1,"")
this will return a percentage only if column F and H contains a number

Frank