{"id":17724,"date":"2022-07-10T20:15:53","date_gmt":"2022-07-10T20:15:53","guid":{"rendered":"https:\/\/vmlogger.com\/excel\/?page_id=17724"},"modified":"2022-09-20T08:23:58","modified_gmt":"2022-09-20T08:23:58","slug":"excel-formulas","status":"publish","type":"page","link":"https:\/\/vmlogger.com\/excel\/excel-formulas\/","title":{"rendered":"Excel Formulas"},"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.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”2_3″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_cta title=”What is Excel Formula?” button_url=”\/excel\/2012\/07\/excel-formula-basics\/” url_new_window=”on” button_text=”Know more” admin_label=”excel-formula” _builder_version=”4.17.6″ _module_preset=”default” background_color=”rgba(113,178,112,0.15)” button_alignment=”center” background_layout=”light” custom_padding=”|20px||20px|false|true” border_color_all=”#7EBDC4″ global_module=”17721″ saved_tabs=”all” global_colors_info=”{%22gcid-e5f9dccd-6b2d-43f6-90c6-ffc410387605%22:%91%22background_color%22%93}”]<\/p>\n

Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).<\/p>\n

[\/et_pb_cta][et_pb_tabs active_tab_background_color=”#FFFFFF” inactive_tab_background_color=”#30657F” active_tab_text_color=”#30657F” _builder_version=”4.17.6″ _module_preset=”default” tab_text_color=”#FFFFFF” global_colors_info=”{}”][et_pb_tab title=”DATE & Time” _builder_version=”4.17.6″ _module_preset=”default” tab_font=”|||on|||||” tab_text_color=”#FFFFFF” background_color=”RGBA(255,255,255,0)” background_enable_color=”on” global_colors_info=”{}”]<\/p>\n\n\n\n\n\n\n\n\n\n\n
DATE Formula<\/a><\/td>\nDATEDIF Function<\/a><\/td>\n<\/tr>\n
DATEVALUE Function<\/a><\/td>\nDAY Function<\/a><\/td>\n<\/tr>\n
DAYS360 Function<\/a><\/td>\nHOUR Function<\/a><\/td>\n<\/tr>\n
MINUTE Function<\/a><\/td>\nMONTH Function<\/a><\/td>\n<\/tr>\n
NOW Function<\/a><\/td>\nSECOND Function<\/a><\/td>\n<\/tr>\n
TIME Function<\/a><\/td>\nTIMEVALUE Function<\/a><\/td>\n<\/tr>\n
TODAY Function<\/a><\/td>\nWEEKDAY Function<\/a><\/td>\n<\/tr>\n
YEAR Function<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

[\/et_pb_tab][et_pb_tab title=”Mathematical” _builder_version=”4.17.6″ _module_preset=”default” tab_font=”|||on|||||” tab_text_color=”#FFFFFF” background_color=”RGBA(255,255,255,0)” background_enable_color=”on” global_colors_info=”{}”]<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
ABS Function<\/a><\/td>\nCEILING Function<\/a><\/td>\n<\/tr>\n
COMBIN Function<\/a><\/td>\nCOUNTIF Function<\/a><\/td>\n<\/tr>\n
EVEN Function<\/a><\/td>\nFACT Function<\/a><\/td>\n<\/tr>\n
FLOOR Function<\/a><\/td>\nINT Function<\/a><\/td>\n<\/tr>\n
MINVERSE<\/a><\/td>\nMMULT<\/a><\/td>\n<\/tr>\n
MOD Function<\/a><\/td>\nODD Function<\/a><\/td>\n<\/tr>\n
PI Function<\/a><\/td>\nPOWER Function<\/a><\/td>\n<\/tr>\n
PRODUCT Function<\/a><\/td>\nRAND Function<\/a><\/td>\n<\/tr>\n
ROMAN Function<\/a><\/td>\nROUND Function<\/a><\/td>\n<\/tr>\n
ROUNDDOWN Function<\/a><\/td>\nROUNDUP Function<\/a><\/td>\n<\/tr>\n
SIGN Function<\/a><\/td>\nSUBTOTAL<\/a><\/td>\n<\/tr>\n
SUM Function<\/a><\/td>\nSUMIF Function<\/a><\/td>\n<\/tr>\n
SUMPRODUCT Function<\/a><\/td>\nTRUNC Function<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

[\/et_pb_tab][et_pb_tab title=”Statistical” _builder_version=”4.17.6″ _module_preset=”default” tab_font=”|||on|||||” tab_text_color=”#FFFFFF” background_color=”RGBA(255,255,255,0)” background_enable_color=”on” global_colors_info=”{}”]<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
AVERAGE<\/td>\nCORREL<\/td>\n<\/tr>\n
COUNT<\/td>\nCOUNTA<\/td>\n<\/tr>\n
FORECAST<\/td>\nFREQUENCY<\/td>\n<\/tr>\n
GROWTH<\/td>\nLARGE<\/td>\n<\/tr>\n
MAX<\/td>\nMEDIAN<\/td>\n<\/tr>\n
MIN<\/td>\nTIMEVALUE<\/td>\n<\/tr>\n
MODE<\/td>\nPERMUT<\/td>\n<\/tr>\n
QUARTILE<\/td>\nRANK<\/td>\n<\/tr>\n
SMALL<\/td>\nSTDEV<\/td>\n<\/tr>\n
STDEVP<\/td>\nTREND<\/td>\n<\/tr>\n
VAR<\/td>\nVARP<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

[\/et_pb_tab][et_pb_tab title=”Text Formulas” _builder_version=”4.17.6″ _module_preset=”default” tab_font=”|||on|||||” tab_text_color=”#FFFFFF” background_color=”RGBA(255,255,255,0)” background_enable_color=”on” global_colors_info=”{}”]<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
CHAR<\/td>\nCLEAN<\/td>\n<\/tr>\n
CODE<\/td>\nCONCATENATE<\/td>\n<\/tr>\n
DOLLAR<\/td>\nEXACT<\/td>\n<\/tr>\n
FIND<\/td>\nFIXED<\/td>\n<\/tr>\n
LEFT<\/td>\nLEN<\/td>\n<\/tr>\n
LOWER<\/td>\nMID<\/td>\n<\/tr>\n
PROPER<\/td>\nREPLACE<\/td>\n<\/tr>\n
REPT<\/td>\nRIGHT<\/td>\n<\/tr>\n
SUBSTITUTE<\/td>\nT<\/td>\n<\/tr>\n
TEXT<\/td>\nTRIM<\/td>\n<\/tr>\n
UPPER<\/td>\nVALUE<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

[\/et_pb_tab][\/et_pb_tabs][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.17.6″ _module_preset=”default” hover_enabled=”0″ sticky_enabled=”0″]

.<\/h2>\t\t
\n\t\t\t