You handled the situation PREFECTLY well done to you!
If it was me I would have lost it (with the nan, I mean)!