There's a setting under:

Tools|option|Calculation Tab
Check Automatic


greg wrote:

Hello,
i avea quick question.
i have formulas in cells. such as this in cell C1:
=IF(A1="","",A1&"/ "&B1)

but when i put a value in A1 it does not evaluate.
i have to go into C1 and hit enter. then it evaluates.
is there a setting in excel that i need to set?

thanks,

--

Dave Peterson