{"id":17667,"date":"2022-07-09T22:20:39","date_gmt":"2022-07-09T22:20:39","guid":{"rendered":"https:\/\/vmlogger.com\/excel\/?page_id=17667"},"modified":"2022-09-01T12:52:10","modified_gmt":"2022-09-01T12:52:10","slug":"user-defined-functions","status":"publish","type":"page","link":"https:\/\/vmlogger.com\/excel\/user-defined-functions\/","title":{"rendered":"Custom Functions"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ da_disable_devices=”off|off|off” global_colors_info=”{}” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on”][et_pb_row column_structure=”2_3,1_3″ admin_label=”row” _builder_version=”4.17.6″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” max_width=”1280px” global_colors_info=”{}”][et_pb_column type=”2_3″ _builder_version=”4.17.4″ custom_padding=”10px|5px|10px|5px|true|true” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_blurb title=”What is User Defined Function (UDF) ?” use_icon=”on” font_icon=”||fa||900″ _builder_version=”4.17.6″ _module_preset=”0249c68e-4de8-4f44-84ff-a9b1850785b6″ global_colors_info=”{}”]<\/p>\n

Microsoft Excel allows us to\u00a0create our own functions, based on our own needs. Such functions are called \u201cU<\/strong>ser\u00a0D<\/strong>efined\u00a0F<\/strong>unctions<\/i>\u201d (UDF<\/strong>s) or\u00a0Custom Function.<\/strong><\/p>\n

These functions behave exactly like Excel\u2019s inbuilt formulas. These are helpful in simplifying complicated calculations or string-related stuff. Sometimes, you might have felt, \u201cI wish, Excel had a built-in formula for this calculation\u201d !! No worry, you can create your own formula.. and through all the dirty code behind the bar<\/p>\n

[\/et_pb_blurb][et_pb_cta title=”How to create your own Excel formula?” button_url=”\/excel\/2014\/05\/how-to-create-custom-functions-in-excel\/” url_new_window=”on” button_text=”4 Steps to create UDFs” _builder_version=”4.17.6″ _module_preset=”default” background_color=”#196985″ button_icon=”$||divi||400″ button_on_hover=”off” border_width_all=”1px” border_color_all=”#E09900″ global_colors_info=”{}”]<\/p>\n

Hearing about creating my own defined formula is exiting and feels like a rocket science but trust it’s not. Learn here in 4 simple steps how to create your own Custom Function.<\/p>\n

[\/et_pb_cta][et_pb_blog fullwidth=”off” posts_number=”6″ include_categories=”2056″ excerpt_length=”200″ show_author=”off” show_date=”off” _builder_version=”4.17.6″ _module_preset=”default” header_font=”|600|||||||” header_line_height=”1.7em” pagination_font=”|600|||||||” pagination_text_align=”center” pagination_font_size=”21px” background_color=”#FFFFFF” custom_padding=”0px|0px|0px|0px|true|true” custom_css_featured_image=”padding:10px 10px 10px;” global_colors_info=”{}”][\/et_pb_blog][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.17.4″ custom_padding=”10px|5px|10px|5px|true|true” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text ul_type=”circle” ul_position=”inside” _builder_version=”4.17.6″ _module_preset=”default” text_font=”|600|||||||” text_text_color=”#E09900″ ul_font_size=”13px” header_text_align=”center” header_2_font=”|700|||||||” header_2_text_align=”center” header_2_text_color=”#E09900″ header_2_font_size=”24px” header_2_line_height=”1.7em” background_color=”#FFFFFF” background_image=”https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/08\/thumbsup-character.gif” background_size=”contain” background_position=”top_left” custom_padding=”10px||10px||true|true” border_color_all=”#7EBDC4″ border_color_left=”#FF4D53″ border_style_left=”none” global_module=”17988″ global_colors_info=”{}”]<\/p>\n

Buy\u00a0a coffee for the author<\/h2>\n
\n

\n\n
\n
\n \n \n \n \n \n \n \n \n \n \n \"\"\n <\/div>\n<\/form>\n\n<\/div><\/p>\n<\/blockquote>\n

[\/et_pb_text][et_pb_text _builder_version=”4.17.6″ _module_preset=”default” global_colors_info=”{}” global_module=”244316″ theme_builder_area=”post_content” admin_label=”subscription”]

\n\t\t\t\t