#N/A – Error in Excel

By Satish dhawale Image by: unsplash Learn more

इस Error का मतलब होता है “No Value Available” या “Not available” है।

[{"selector":"#anim-3eae7f92-0a32-4d17-810e-dde8a7d52364","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3967f4cc-4ea9-4420-83dd-cdd26b9dc23d","keyframes":{"transform":["translate3d(114.10658%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Image by: unsplash Learn more

यह हमे यह बताता है कि Formula उस वैल्यू (value) को नहीं ढूंढ पा रहा है जिसे हम formula के जरिए ढूढ़ने की कोशिश कर रहे है।

[{"selector":"#anim-d6e53124-7b1a-4ffe-a8b7-7919f1adb4c5","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-317de977-1246-4bc1-be17-3ec7267894f9","keyframes":{"transform":["translate3d(118.72909%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] By Satish dhawale Image by: unsplash Learn more

Excel में VLOOKUP, HLOOKUP, MATCH, और LOOKUP फ़ंक्शन का उपयोग करते समय यह Error ज्यादा देखने को मिलता है।

[{"selector":"#anim-456ae25d-1c34-4052-9daf-b59c9997a258","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-eb34a52b-7cfc-4862-955d-cb538fdc90e6","keyframes":{"transform":["translate3d(0px, 152.26553%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] By Satish dhawale Image by: unsplash Learn more

यदि हमें तर्क के रूप में हमारे द्वारा प्रदान किए गए Source Data में Referenced value नहीं मिलता है, तो हमें यह Error मिलेगा।

[{"selector":"#anim-aec96b04-4245-4871-8796-fa40eaa820e2","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-02420658-9c73-4478-b709-eb09d1d52b12","keyframes":{"transform":["translate3d(120.83334%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] By Satish dhawale Image by: unsplash Learn more

ऊपर दिए गए इमेज मे हम देख सकते है कि Reference Value हमारे डाटा मे उपलब्ध ही नहीं है इसे हमे यह Error प्राप्त हो रहा है।

[{"selector":"#anim-3c0b3930-92f4-4e64-8612-89d6b52a1eec","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-38aa3f0d-1c17-42b9-a927-43c68277024f","keyframes":{"transform":["translate3d(0px, -242.46705%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] By Satish dhawale Image by: unsplash Learn more

इस Error को सही करने के लिए आपको Reference Value की जांच करनी होती है जिससे यह पता चले कि जो वैल्यू हम ढूंढ रहे वह हमारे डाटा मे है या नहीं।

[{"selector":"#anim-7fc67f37-cbb4-4682-8a7d-0db04ea7deec","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2cc50b35-955f-401c-b526-febcd190338a","keyframes":{"transform":["translate3d(0px, 123.13131%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] By Satish dhawale Image by: unsplash Learn more

इसी तरह के Excel Error सीखने के लिए नीचे दिए लिंक पे Click करें।

[{"selector":"#anim-b5152f74-55fa-475f-a3a5-a9871a08daea","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0070ccce-c746-4507-839c-7015a3863c81","keyframes":{"transform":["translate3d(-115.89405%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ce5cffef-0aee-42f2-b81c-771f278fb2bf","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-561757ca-6d49-4810-ac8b-8c6512076d05","keyframes":{"transform":["translate3d(116.45570%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] By Satish dhawale Image by: unsplash Learn more