{"id":1251,"date":"2020-06-17T21:00:48","date_gmt":"2020-06-17T15:30:48","guid":{"rendered":"https:\/\/www.complianceprime.com\/blog\/?p=1251"},"modified":"2020-06-17T21:00:48","modified_gmt":"2020-06-17T15:30:48","slug":"top-5-excel-functions-how-to-use-them","status":"publish","type":"post","link":"https:\/\/www.complianceprime.com\/blog\/2020\/06\/17\/top-5-excel-functions-how-to-use-them\/","title":{"rendered":"Top 5 Excel Functions: How To Use Them"},"content":{"rendered":"

Using an Excel sheet while preparing some presentations, or accounts can be a daunting task without the knowledge of its functions. There are various functions in Microsoft Excel that you can use to create shortcuts and ease your work.\u00a0<\/span><\/p>\n

 <\/p>\n

Let\u2019s see some of the Microsoft Excel and how you can use them.<\/span><\/p>\n

IF Function<\/span><\/h2>\n

Excel\u2019s most popular function is the IF function, it helps to make a logical comparison between values and what you expect from them. It always has two results option, either true or false. You can use the IF function to test a condition, if the condition is a true return to one value and if the condition is a false return to another value.\u00a0<\/span><\/p>\n

 <\/p>\n

Example: If the number in cell A2 is greater than 5, the formula returns “OK”; otherwise 0 is returned. Formula example for the same: <\/span>=IF(A2>5, “OK”,)<\/span><\/i><\/p>\n

 <\/p>\n

AND Function<\/span><\/h2>\n

The AND function of excel is a logical function. If you wish to get more than one condition at the same time, you can use AND function. Inside the IF function, it can be used as the logical test if you want to avoid extra nests of IF functions. You can also combine AND function with the OR function.<\/span><\/p>\n

\u00a0<\/span><\/p>\n

Example: Test if a number in A5 is greater than zero and less than 15.<\/span> =AND(A5>0, A5<15)<\/span><\/i>. The function here will test two results for A5.<\/span><\/p>\n

 <\/p>\n

OR Function<\/span><\/h2>\n

To test the multiple conditions at the same time you can use the OR function. Just like AND function OR function also returns either \u201ctrue\u201d or \u201cfalse\u201d. Inside the IF function, you can use the OR function to avoid extra Ifs. You can also combine OR with AND to get the results.\u00a0<\/span><\/p>\n

 <\/p>\n

Example: To test A5 for either \u201cx\u201d or \u201cy\u201d. =OR(A5=\u201dx\u201d, A5=\u201dy\u201d). again just like AND the OR function will test two results for A5.<\/span><\/p>\n

 <\/p>\n

VLOOKUP Function<\/span><\/h2>\n

In VLOOKUP, \u201cV\u201d stands for vertical. If you have organized a table vertically in Excel and you need to find or retrieve data from it, you can use the VLOOKUP function of Excel. VLOOKUP supports exact matches and use (* ?) for partial matches. This function\u2019s main purpose is to look up to a value in a table by matching the first column. In return, you get the matched value from the table. The syntax is <\/span>VLOOKUP<\/span><\/i> (value, table, col_index, [range_lookup])<\/span><\/i>. Here:<\/span><\/p>\n

 <\/p>\n

    \n
  • Value= the value to look for in the first column of a table.<\/span><\/li>\n
  • Table= the table from which data needs to be retrieved.<\/span><\/li>\n
  • Col_index= the column in the table from which to retrieve a value.<\/span><\/li>\n
  • Range_lookup= TRUE= approximate match, and False= exact match.<\/span><\/li>\n<\/ul>\n

     <\/p>\n

    HLOOKUP Function<\/span><\/h2>\n

    In HLOOKUP, \u201cH\u201d means horizontal. Just like VLOOKUP, HLOOKUP also helps in finding, and retrieving data, the only difference is that it performs a horizontal lookup by searching for a value in the top row and return the value in the same column based on the index_number. you can use the syntax, <\/span>HLOOKUP(value,table,index_number,[approximate_match])<\/span><\/i>, here:<\/span><\/p>\n

     <\/p>\n

      \n
    • Value= the value to search for in the first row of the table.<\/span><\/li>\n
    • Table= two or more rows of data that is sorted in ascending order.<\/span><\/li>\n
    • Index_number= the row number in the table from which the matching value must be returned.<\/span><\/li>\n
    • Approximate_match= TRUE= approximate match, and False= exact match.<\/span><\/li>\n<\/ul>\n

       <\/p>\n

      Using Excel functions is no rocket science, in just an attempt or two, you can easily start using it without any hassles. The functions are here to ease your problems and make your work smoother.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

      Using an Excel sheet while preparing some presentations, or accounts can be a daunting task without the knowledge of its functions. There are various functions in Microsoft Excel that you…<\/p>\n","protected":false},"author":4,"featured_media":1254,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[6],"tags":[98],"class_list":["post-1251","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office","tag-microsoft-excel"],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/www.complianceprime.com\/blog\/wp-json\/wp\/v2\/posts\/1251","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.complianceprime.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.complianceprime.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.complianceprime.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.complianceprime.com\/blog\/wp-json\/wp\/v2\/comments?post=1251"}],"version-history":[{"count":0,"href":"https:\/\/www.complianceprime.com\/blog\/wp-json\/wp\/v2\/posts\/1251\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.complianceprime.com\/blog\/wp-json\/wp\/v2\/media\/1254"}],"wp:attachment":[{"href":"https:\/\/www.complianceprime.com\/blog\/wp-json\/wp\/v2\/media?parent=1251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.complianceprime.com\/blog\/wp-json\/wp\/v2\/categories?post=1251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.complianceprime.com\/blog\/wp-json\/wp\/v2\/tags?post=1251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}