The ISNUMBER formula will only respond to any integers entered and ignores anything else like for instance "A" or "c" in any of the three columns. I would therefore suggest using =IF(A2<>0,IF(B2<>0,IF(C2<>0,"YES","NO"),"NO"),"NO") instead
Thanks for the rep ... glad to help. What's the weather like in Norway at the moment? We'll be visiting in a couple of weeks for a cruise up the coast from Bergen. Hoping to see the Northern Lights! What are the chances!? Kind regards
Find latest posts