FORMULAS Archives - Page 12 of 17

Dec112020 by excelhelp13No Comments

Compare Month From Two Different Dates In Excel

Definition:- With The Help Of Month Function You Can Compare The Month From A Given Dates. The Result Will Be Boolean True or False. How It Works:- Excel Will Find The Month From First Date And Then From Second Date And Convert The Result Into True or False. Please Check The Image & Video Below. EXAMPLE :- 1 EXAMPLE:- 2 To Find Or Check Whether Today's Date Has The Same Month As Compare To The Other Provided Date Please Use The Below Mentioned Formula. =MONTH(Date)=MONTH(TODAY())

Dec112020 by excelhelp13No Comments

Extract Quarter From Date In Excel

Date And Time, FORMULAS

DEFINITION:- With The Help Of Month Function You Can Extracts The Quarter From A Given Date. The Result Will Be Between 1 To 4 Number. EXAMPLE :- 1 EXAMPLE :- 2

Dec112020 by excelhelp13No Comments

Extract Month From Date

Date And Time, FORMULAS

DEFINITION:- With The Help Of Month Function You Can Extracts The Month From A Given Date. The Result Will Be Between 1 To 12 Number. EXAMPLE :- 1 EXAMPLE :- 2

Dec22020 by excelhelp13No Comments

Compare Time Using If Formula

Logical, Statistical

First Select Any Of The Cell For Output Result. Apply The Formula '=IF(TIME(11,17,30)=D2,"Yes","No") Make Sure That Time After 12:00 Hr Is 13:00 As By Default The Time Value Is In 24 Hrs Format. If You Change The Format To 12 Hrs Then It Fine to Have 01;00 Hrs. But Its Vary With Time Formats. As A Result You Can Choose The Output With If Formula. That's It: :)

Dec22020 by excelhelp13No Comments

Split Or Extract The Data Having More Than One Line In Single Cell

FORMULAS

To Extract Or Split These Type Of Data Please Follow The Step Shown Below.First Select The Cell Having That Kind Of Data.Copy The Cell.Now Open The Note Pad.Remove Double Quote From Start Point And From End Point.Now Copy All Data From Notepad Ctrl + A.Now Go To Excel And Select The Same Range Or Cells Or Whole Column Where You Want The Data To Get Populate.Now Right Click And Paste As Text And You Will Have All Those Data In Separate Cells.Now If Needed Copy Those Data And Transpose T o Column From Rows.That's It :)

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 :)

Apr132020 by excelhelp13No Comments

DEPENDENT Drop Down List In Excel

Lookup & Reference

TO create a dependent drop down list please follow the step shown below and example provided with image and video under it. First Select The Reference Cell Where you Want To Have Drop Down List.Then GO To Data Tab.Then Go To Data Validation.One Dialog Box Will Pop-Up.Under That Select The List From Drop Down List.Then Under That In Source Tab Just Provide The Reference Range And Click Ok.Once Your Drop Down List Created Move To Next Column Cell.Then Again Go To Data Validation And Paste This Formula =OFFSET($D$1,1,MATCH($A2,$D$1:$F$1,0)-1,10,1) And Click Ok.OFFSET FUNCTION:- Offset Function Return A Reference To A Range For The Given Number Of Rows And Columns For The Given Reference.MATCH FUNCTION:- Match Function heck The Position Of A Particular Reference In A Given Array.NOTE:- If ...

Apr72020 by excelhelp13No Comments

PRINT TITLE On Every Page In Excel

FORMULAS, Page Layout, Statistical

How to use the already built in function in excel for printing the title on every page. Please follow the step mentioned below. GO to Page Layout.Then go to Print Tiles and click on it.Then you will see One Dialog Box Will Appear.In that dialog box go to the Repeat On Top Option.After that select the option showing Title range.Then simply click ok button located at bottom right in dialog box.That's it :)

Apr72020 by excelhelp13No Comments

SUM AVERAGE MAX & MIN Function In Excel.

FORMULAS, Maths

For using these 4 function in excel and to know the actual purpose of all those function. Please follow the step mentioned below. SUM () function add all the numeric value available in different range. SUM() function only need the reference range For Example:- =SUM(B2:C7)AVERAGE () function add all the numeric value available in different range and divide it by the counting the cell with numeric value available. Suppose there are 4 cell and its total is 100 then Average () function will divide 100 by 4 100/4 = 25 is the average. For Example:- =AVERAGE(B2:C7)MAX() function find the bigger number from the given range or a cell reference. Suppose there are 4 cell and its contain 10, 20, 30, 40, then MAX() function will give you the 40 as a max number. For Example:- =MAX(B2:C7)MIN() functi...