| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF function not calculating
Help! I have a number of IF functions set up and they appear to not
automatically calculate. When I change the value in the logical argument, the values in the cell that the function is nested in do not change. However, when I click the function button on the function box the function calculates. Any help would be GREATLY appreciated! Richard |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function not calculating
Make sure calculation is set to automatic.
ToolsOptionsCalculation tabAutomaticOK -- Biff Microsoft Excel MVP "rvctrey" wrote in message ... Help! I have a number of IF functions set up and they appear to not automatically calculate. When I change the value in the logical argument, the values in the cell that the function is nested in do not change. However, when I click the function button on the function box the function calculates. Any help would be GREATLY appreciated! Richard |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function not calculating
Thanks, I figured this out shortly after posting. Pretty cosmic.
"T. Valko" wrote: Make sure calculation is set to automatic. ToolsOptionsCalculation tabAutomaticOK -- Biff Microsoft Excel MVP "rvctrey" wrote in message ... Help! I have a number of IF functions set up and they appear to not automatically calculate. When I change the value in the logical argument, the values in the cell that the function is nested in do not change. However, when I click the function button on the function box the function calculates. Any help would be GREATLY appreciated! Richard |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function not calculating
Good deal!
-- Biff Microsoft Excel MVP "rvctrey" wrote in message ... Thanks, I figured this out shortly after posting. Pretty cosmic. "T. Valko" wrote: Make sure calculation is set to automatic. ToolsOptionsCalculation tabAutomaticOK -- Biff Microsoft Excel MVP "rvctrey" wrote in message ... Help! I have a number of IF functions set up and they appear to not automatically calculate. When I change the value in the logical argument, the values in the cell that the function is nested in do not change. However, when I click the function button on the function box the function calculates. Any help would be GREATLY appreciated! Richard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating using the Median function?? | Excel Discussion (Misc queries) | |||
| Sum function not calculating? | Excel Discussion (Misc queries) | |||
| using min function without calculating 0 as minimum | New Users to Excel | |||
| Function Key for Calculating Average? | Excel Worksheet Functions | |||
| If function calculating date | Excel Worksheet Functions | |||
Linear Mode
