#NULL! – Error in Excel

By Satish dhawale Image by: unsplash Learn more

#NULL! यह Error आमतौर पर तब आती है जब Cell Reference सही ढंग से नहीं लिखा गया हैं।

[{"selector":"#anim-ca771f2e-3664-4d21-bb69-71e3f47147b1","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4b9cb306-12a0-4baa-989c-75d4e47234d2","keyframes":{"transform":["translate3d(113.79312%, 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

हमें यह Error तब मिलती है जब हम किसी फार्मूला मे स्पेस कैरेक्टर (space character) का सही उपयोग नहीं करते हैं।

[{"selector":"#anim-261a8d74-9a3a-4d1f-a170-e057d892c1ce","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-969c2f98-ec22-41c8-a3de-f61f6345fc10","keyframes":{"transform":["translate3d(116.38795%, 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

स्पेस कैरेक्टर (space character) को इंटरसेक्ट ऑपरेटर (Intersect Operator) भी कहा जाता है,

[{"selector":"#anim-99f12cc7-bf6d-4feb-a14f-fd99e9b55ce6","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-cfde8c1d-504b-4970-bab0-51f57c3343c2","keyframes":{"transform":["translate3d(0px, 195.40742%, 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

क्योंकि इसका उपयोग उस Range को निर्दिष्ट करने के लिए किया जाता है जो किसी भी सेल में एक दूसरे को काटती है।

[{"selector":"#anim-c911f66a-6997-4ff9-94ed-7785e8ec119a","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-261ded3e-b107-458e-b4ab-98831343e7cd","keyframes":{"transform":["translate3d(0px, 142.28695%, 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

इमेज में, हमने स्पेस कैरेक्टर का उपयोग किया है, लेकिन रेंज B2:B11 और C2:C12 प्रतिच्छेद नहीं कर रहे हैं; इसलिए यह Error दिख रही है।

[{"selector":"#anim-4224c729-a68e-4607-ac7b-beaa0d54df41","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3e3f18b2-16b7-4914-82ba-3aa899371258","keyframes":{"transform":["translate3d(122.10526%, 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

इस Error को सॉल्व करने के लिए आपको Formula मे उसके Argument के अनुसार सही ढंग से यूज करना होता है।

[{"selector":"#anim-0b626bbf-a200-426e-8314-82bcd95dfef7","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-70cde482-4513-45be-85ea-bd39455144f8","keyframes":{"transform":["translate3d(0px, -243.07329%, 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-4ccc1f59-2591-4228-a6af-15bdf01b33e6","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-491e940c-0396-4c6a-aefb-10fbe2aca4ea","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-d2cfaae2-95e8-4977-ad98-6fc0238ff6dc","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9285e330-fdf2-4104-a9f7-afd4ab08602d","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