| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not Calculating Formulas. | Excel Worksheet Functions | |||
| Formulas not calculating | Excel Worksheet Functions | |||
| not calculating formulas | Excel Discussion (Misc queries) | |||
| Formulas not calculating??? | Excel Discussion (Misc queries) | |||
| Formulas not calculating | Excel Worksheet Functions | |||
Linear Mode
