Formulas not calculating
 

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,

Formulas not calculating
 

Hi
goto 'Tools - Options - Calculate' and ebale 'Automatic Calculation'

--
Regards
Frank Kabel
Frankfurt, Germany


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,

Formulas not calculating
 

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

thanks all!!!
 

"greg" wrote in message
...
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,