#NAME? – Error in Excel

By Satish dhawale Image by: unsplash Learn more

#NAME यह एरर हमे इक्सेल मे स्पेलिंग मिस्टैक के कारण आता हैं।

[{"selector":"#anim-67bc7836-a474-4e74-82fa-0cdaeda83c83","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-542a1478-2d47-4f2a-8d55-fe7b3d7b4082","keyframes":{"transform":["translate3d(113.47963%, 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

Excel मे यह Error तब देखने को मिलता है जब हम आमतौर पर Formula नाम गलत तरीके से लिखा गया हो या हमसे Formula की स्पेलिंग मिस्टैक हो जाए।

[{"selector":"#anim-bc7a0384-e373-42d3-adc6-2543fd2aeae7","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ec574d81-72e9-41c9-a3b5-b2d75986dc10","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

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

[{"selector":"#anim-173177ca-b394-4423-9a65-187f9d5dae8a","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-020825c5-0f8e-4eb7-8ae6-c1bfb1348f5d","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

ऊपर इमेज मे बताए गए फार्मूला मे Vlookup की स्पेलिंग गलत Vlokup लिखी गई है, इसीलिए यह Error प्राप्त हो रहा है।

[{"selector":"#anim-28ee79b5-4bd9-4344-ab48-9a3fcfea21c3","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-eb3b9085-a007-4b1e-b94a-5703b832d3d8","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"}] [{"selector":"#anim-791171c3-4dc6-4011-a414-3b2a68380b12","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-06b911c7-7b2c-4fbb-9a42-fa25a59a173d","keyframes":{"transform":["translate3d(-114.42007%, 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 की स्पेलिंग सही लिखनी होती है।

[{"selector":"#anim-e53df451-ace3-4c0f-ace0-66771722f376","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-fa289a44-632d-4452-99a5-dab6e9b63ccd","keyframes":{"transform":["translate3d(0px, -301.3307%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6229f64f-3f9d-472e-a361-1380b558eafb","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-142cafa4-0155-4f32-8be8-97549202381a","keyframes":{"transform":["translate3d(123.52942%, 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 Error सीखने के लिए नीचे दिए लिंक पे Click करें।

[{"selector":"#anim-22b7b81c-9b16-405a-91d2-8f2119f99aca","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-36f295ee-bdba-4d15-a2c0-cdbbb83d8878","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-1364793f-063c-4406-a97b-20ef4e99305e","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a7bd4359-a523-40d7-9d29-8e6c941e2e83","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