This is the same as California. If the CEL is on, the car automatically fails.
One thing you should be aware. When the dealership turns the CEL off, the car’s computer knows about it. And it will tattle on you when you go back for the next test. So it might fail again, due to a CEL reset having been recently done. The car takes a while to decide whether the emissions equipment is working or not. The car has to go through a series of driving procedures before it decides whether the CEL should be on or not, and until that is done, which may take days or a few weeks depending on your driving habits, they may tell you they can’t test it. This is done to prevent the owner from disconnecting the battery to turn off the CEL light in order to pass the test.
If you Google “how to pass a New York emissions test”, you’ll probably get some good info. Or if you don’t see anything there, try “How to pass a California emissions test”. There’s some good tips on some of those websites, one of the tips being “Make sure the CEL is off before you go to the test”.