9 Types Error in Excel

By Satish dhawale Image by: unsplash Learn more

#NUM! Excel में यह Error फार्मूला के argument में invalid number के कारण आता हैं।

[{"selector":"#anim-594968c2-bf99-4ee4-8d80-2956d6532a71","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-312ef2ad-9c62-4149-b2cc-8c6dd790cd38","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

#DIV/0 एक Formula में दो वैल्यू को Divide करते समय यदि Divider 0 हो तो हमे Excel मे DIV/0 Error आता है।

[{"selector":"#anim-44d7cc7a-9323-46a0-9c6e-a1a153d97c6e","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-674e70d1-ba34-4486-8cd3-eb99425d65ad","keyframes":{"transform":["translate3d(119.12751%, 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

#N/A VLOOKUP, HLOOKUP, MATCH, और LOOKUP का यूज करते समय जब वैल्यू नहीं मिलती है तो यह एरर आता हैं।

[{"selector":"#anim-6f8b30ef-bfc2-4e63-9f4b-8e471a9d13cc","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f1a2be9d-f932-4d8a-a723-7767595b24e2","keyframes":{"transform":["translate3d(116.01308%, 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

#NAME? Excel मे यह Error तब देखने को मिलता है जब हम आमतौर पर Formula नाम गलत तरीके से लिखा गया हो

[{"selector":"#anim-18886af5-b7de-418c-b2ea-7f7e04a163ff","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1bf2c6cb-d2b7-44f7-9a72-f3125111f3fc","keyframes":{"transform":["translate3d(116.01308%, 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

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

[{"selector":"#anim-955dd696-2e19-491c-8230-9299a593a06c","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ccb68eb5-80fa-4eb2-adea-ddad7b068de2","keyframes":{"transform":["translate3d(119.12751%, 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

#REF! गलती से सेल को डिलीट कर दिया है या 1. Referenced Cell को एक जगह से दुसरी जगह पे Cut और Paste कर दिया हैं।

[{"selector":"#anim-58464a3c-8848-482d-a4ab-e79522393a70","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c91d9faf-061c-41ad-b2d2-640915837abb","keyframes":{"transform":["translate3d(117.64707%, 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

#VALUE! यह Error तब आती है जब हम किसी Function or Formula के लिए गलत Data Type का उपयोग करते हैं।

[{"selector":"#anim-4df004c6-bd7b-4dca-8029-196ae78edf76","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c8d2decd-29d7-49a5-8be5-81bc4e6387b2","keyframes":{"transform":["translate3d(120.13652%, 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 तब प्रदर्शित होती है जब Excel में कॉलम की चौड़ाई सेल में स्थित वैल्यू को दिखने के लिए पर्याप्त नहीं होती है।

[{"selector":"#anim-362dcdab-89ad-4f83-88a4-11192e4697a1","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f6d4d6b7-1231-4b5c-b870-aa131bc8ca25","keyframes":{"transform":["translate3d(115.46052%, 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 सीखने के लिए नीचे दिए लिंक पे Click करें।

[{"selector":"#anim-cd0ea3d3-ef7e-4f90-8128-3dfaef203898","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ebeaaa27-3275-4123-a279-51ff69f82fef","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-2c4568aa-691d-45e7-aadc-d50f51fbc3ae","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d70a9777-9db2-48c5-a5d7-7a8659a99351","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