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 |