Maybe you're not in automatic calculation mode.

In xl2003 menus:
tools|Options|calculation tab
(make it automatic)



Steve wrote:

I not sure how to put this, but I have formulas that aren't working until I
'refresh??' them.
Here's one of thr
formulas:=IF('Rollup'!G15-'Rollup-prior'!G15<0,'Rollup'!G15-'Rollup-prior'!G15,"")

Basically, if I change the G15 data, the result of the formula doesn't
change until I place the cursor in front of the = in the formula bar,then hit
enter. When I do that, the formula works.

Thanks,

Steve

--

Dave Peterson