Thread: Formulas not calculating
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
greg greg is offline
external usenet poster
  
Posts: 59
Default 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,


Reply With QuoteReply With Quote