Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Strange formula 'non-calculation'
Hi,
I'm having a problem in Excel 2003 ... SP1. I'm trying to do something very simple: populate cells in several sheets with text based on text strings from a master sheet. Here's the formula: =IF($B$6="M",0,IF(ISBLANK('Threshold Determination'!D68),"",'Threshold Determination'!D68)) For now, the value in 'Threshold Determination'!D68 is 1. If I type this formula into the cell and hit enter, it works. Likewise, if I fill down from higher rows, it works. The problem occurs when D68 is blank originally, and I change it to 1. The formula doesn't react to show a 1 in the cell. I just get a blank. Calculation is set to automatic. And here's the weird thing. This procedure has been working for me in another worksheet that is essentially the same, except it is being populated with values from another plant (manufacturing). Formula auditing provides no help. For the last step, =IF(FALSE,N/A,'Threshold Determination'!D68) evaluates to nothing, when there is clearly a value in D68. This is maddening. Thanks for your help in advance. Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strange Occurrence Copying Formula | Excel Discussion (Misc queries) | |||
Strange behavior in INDEX(..., MIN(...)) - array formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Initial Formula Calculation | Excel Discussion (Misc queries) |