excel formula Archives

Mar32023 by excelhelp13No Comments

Create Dynamic Dropdown list with Indirect formula

A Dynamic dropdown list or dependent dropdown list is very useful while working in Excel. Which makes our work easier and time get saved. Here we have an example of how to create a dynamic dropdown list or dependent dropdown. Example- We have names of some states and their cities. While working in Excel, you should create a dropdown list so that you do not have to type the name of the state or it's city repeatedly. If we select the state name in dropdown the list of cities of that state will appear automatically. We have the following data. In which dropdown list is to be created in column F3 to G6. Steps- To create a dropdown list of state names Select F3 to F6 In the Data tab, Click on Data Validation. In the dialog box that opens, select “L...

Dec102020 by excelhelp13No Comments

ScreenShot In Excel

Insert Menu, Menu Bar

Definition:- Using The Screenshot Option You Can Quickly And Easily Add A Screenshot To Your Worksheet To Enhance Readability Or Capture Information Without Leaving The Program That You Are Working In. This Feature Is Available In Excel Above Version Of 2007. Steps:- Insert Tab > Screenshot.Choose Window Thumbnail In Available Windows Or Use Screen Clipping.Format And Crop Your Screenshot In Excel.You Can Also Take The Quick Snap Shot Of Other Open Application And Quick Add To Your Worksheets.

Dec82020 by excelhelp13No Comments

Orientation In Excel

Home Menu, Menu Bar

Definition:- The Orientation Command Can Adjust The Text Vertical And Diagonally By Rotating The Cells Text Clockwise And Counter-Clockwise 90 Degrees. Step 1- Select The Cell You Want To Format And Click On Orientation Button. Step 2 – Select The Option In The Orientation Options As Per Your Requirement And Get The Result. For Example:- Please Check The Image Below.

Nov302020 by excelhelp13No Comments

Rank Function In Excel

Maths, Statistical

Open Excel File.Select The Cell Where you Want To The Result To Get Populated.Then Add This Formula In Particular Cell =RANK(10,A1:A10)There Is Third Optional Parameter (Ascending / Descending ) =RANK(10,A1:A10, 1 'For Ascending Order') or =RANK(10,A1:A10, 0 For Descending Order)Make Sure To Lock The Range By $ Sign.Descending Order Is By Default Set Optional Parameter.That's it :)

Apr132020 by excelhelp13No Comments

FIND SMALLEST Number With Position In Excel

Statistical

First Select The Cell Where You Want The Result.Then Apply The Formula And Select The Array / Range And Define The Position. Once Applied It Will Check In The Array And Give You The Result By Finding The Position Of The Smallest Number.That's It :)

Mar312020 by excelhelp13No Comments

PERCENTAGE In Excel

FORMULAS, Maths

There is a Simple way of finding the percentage. Multiply the obtain marks , score or anything you have scored out of the total scoreboard then multiply the value into 100 and divide the sum of total scoreboard value and as a result the value found will be your percentage. For example there are 4 subject of 100 marks each so sum of total marks = 400 and assume that 1 student got 60 marks each in every 4 subject so in total he obtain 240 marks from sum of total 400 marks. So as a result the Formula will be Obtain marks * 100 / Total Marks. = 240 *100 / 400 = 60% According to math for finding percentage is to divide the numerator by the denominator then multiply the output with 100. Suppose you want to find the percentage of 50/100 then divide 50 with 100 the answer will be 1/2 the multi...

Mar162020 by excelhelp13No Comments

ROW Function In Excel

FORMULAS, Lookup & Reference

ROW function in excel is used to know the row number. It will give the the row number in according to the reference given. Example given below in image and video. FORMULA: =ROW(A2)

Mar162020 by excelhelp13No Comments

RIGHT Function In Excel

FORMULAS, Text

Excel RIGHT function extracts number of characters from the right side to a given cell reference. For example, =RIGHT("Game",3) gives"ame". Example given below in image and video. FORMULA: =RIGHT(B2,3)

Mar162020 by excelhelp132 Comments

LEFT Function In Excel

FORMULAS, Text

LEFT function is used to extract the specific number of letter or a word from a particular cell. It has only two parameter.First cell reference and second number of character. Left function extract from left starting position. For example "Excel help is a great website" and now if someone need to extract only Excel or Excel help then Left function is the best choice to use it. Example shown below in image and video FORMULA; =LEFT(A2,5)

Mar162020 by excelhelp131 Comment

BAHTTEXT In Excel

FORMULAS, Text

BAHTTEXT function in excel convert the numbers into text (baht) is one kind of symbolic character. Example shown below in image. FORMULA: =BAHTTEXT(A2)