Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cells will not calculate
I am using the replace feature to modify a rather long formula. I have to
modify it in each column, abour 30 cells per column. Anyway I am replacing $D with $E = the replace feature works perfectly but after the change the cell does not calculate and return the data... HELP. It is far to tedious to make the chabge manually. =IF(ISNA(MATCH("N12",Schedule!$D$49:$D$102,0)),"", INDEX(Schedule!$B$49:$B$102,MATCH("N12",Schedule!$ D$49:$D$102,FALSE))) |
#2
|
|||
|
|||
Cells will not calculate
Even with calculation set to manual, the cell should recalculate after
making a find and replace change. Your formula is set to return a blank, "", if the MATCH portion of the formula fails. Does the value of N12 exist in Schedule!E49:E102? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Order of selecting unprotected cells | Excel Discussion (Misc queries) | |||
Calculate matching cells | Excel Worksheet Functions | |||
HOW NOT TO CALCULATE CELLS IF ONE CONTAINS "0" | Excel Worksheet Functions | |||
calculate percentage of two cells | Excel Worksheet Functions | |||
calculate the sum of cells where values are between 6 and 10 in e. | Excel Worksheet Functions |