ISNA help

[Matt]

The ISNA function does not seem to be updating when I put new data in the
cells that the formula is calculating for. The only time it is doing the
update is if I enter into the cell and then press enter...any suggestions?
Thanks!

 

[Teethless mama]

Tools>Options>Calculation tab>Select Automatic