ExcelBanter - Formulas not calculating

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formulas not calculating (https://www.excelbanter.com/excel-worksheet-functions/5338-formulas-not-calculating.html)

greg

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,

Frank Kabel

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,

Dave Peterson

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

greg

"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,

All times are GMT +1. The time now is 05:33 AM.