Thread: Formulas not calculating
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default 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,
Reply With QuoteReply With Quote