excel function Archives

Mar42023 by excelhelp13No Comments

CEILING Function in Excel.

Menu Bar, View

The CEILING Function Rounds a Number Up to its Nearest Multiple of Significance. CEILING Function helps to round up the numbers as per the requirement. Syntax: =CEILING(Number,Significance) Arguments: Number: The value that you want to Round Up. Significance: The Multiple that you want to Round Up. See the Examples in blow Image.

Jun92022 by excelhelp13No Comments

Data transpose Dynamically in Excel

tips & Tricks

Transpose function is use to exchange the data from Row to Column and Column to Row. To make your data get update automatically by using transpose function please follow the below mentioned steps. STEPS : Select destination range. (Where you want to transpose data)Type formula =transpose(source data range)Press Ctrl + shift + enter 4. See the result in below image. Data transposed within the selected range. 5. When we edit the source data, the transposed data will changed automatically. See the image below.

Jun22022 by excelhelp13No Comments

Strikethrough Effect in Excel

Home Menu, Menu Bar

Strikethrough Effect is Useful for drawing a line in the center above the data / text in the cell to mark it as a completed or to display as depricated or non use as per the needs vary. How to Insert Strikethrough Effect in Excel ? For Example:- excelhelp.in Steps:- Select DataClick Home tab > format > Format cell… or right click on any cell > Format cell… The format cell dialog box will open.Click on font tab > font effectCheck on Strikethrough box.Click OK How to Remove Strikethrough Effect in Excel ? Select the data.Click Home tab > format > Format cell… OR right click on any cell > Format cell… The format cell dialog box will open.Click on font tab > font effectUnCheck on Strikethrough box.Click OK

Dec222020 by excelhelp13No Comments

ISEVEN Function In Excel To Check Even Value

FORMULAS, More Functions

DEFINITION:- Even Numbers Are All The Numbers Which Are Divisible By 2 Either Positive Or Negative. ISEVEN Function Returns True When A Numeric Value Is Even, And False For Odd Numbers. ISEVEN Will Return The #Value Error When A Value Is Not Numeric. SYNTAX:- =ISEVEN (VALUE)

Dec222020 by excelhelp13No Comments

INFO Function To Know Environment Of Excel

FORMULAS, Text

DEFINITION:-The Excel Info Function Returns Information About All The Current Environment In Excel Application Including Platform, Version Of Excel, Number Of Active Worksheets In An Active Workbook And So On. To Use The Info Function In Excel Supply The Type Of Information And Excel Will Provide The Result In Text There Are Seven Types Of Information Available. TypeInformationSyntaxDIRECTORYPath Of The Current Directory.=INFO(“DIRECTORY”)NUMFILENumber Of Active Worksheets.=INFO(“NUMFILE”)ORIGINThe Cell That Is In The Top, Left-Most Cell Visible In The Current Excel Spreadsheet.=INFO(“ORIGIN”)OSVERSIONOperating System Version.=INFO(“OSVERSION”)RECALCReturns The Recalculation Mode - Either Automatic Or Manual=INFO(“RECALC”)RELEASEVersion Of Excel That You Are Running.=INFO(“RELEASE”)SYST...

Dec122020 by excelhelp13No Comments

Find Time Difference In Excel

Date And Time, FORMULAS

DEFINITION:- To find the time difference we can use subtract method from a give two time values. But what if we have date & time together in each cell or both value has in it ? No matter here the TEXT FUNCTION comes in action. With the help of Text function we can first extract the time value from the date and time and then subtract it from one value from another value. Note:- Make sure you have time format set for the output cell. please check the image below.

Dec112020 by excelhelp13No Comments

Count Networks Days Between Dates

Date And Time, FORMULAS

Definition :- There Is A Function Called Networkdays In Excel That Help To Find Out The Number Of Working Days Between Two Given Date Range. It Required Parameter Is Start Date And End Date. For More Info Please Check In Image And Video Below. Validation :- Make Sure That You Must Have Input Valid Start Date & End Date In The Function. Other Wise It Will Give You #Num Error.Make Sure You Have Added Date In Proper Format According To Your PC Settings. Make Sure That You Have Proper Format Date When You Give A Direct Cell Reference As Shown In Image.In Image And Video # Example Are Provided Please Have A Look.

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

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 excelhelp132 Comments

SUBSTITUTE Function In Excel

FORMULAS, Text

Excel SUBSTITUTE function is a string function which used to replace a particular word - sentence from a cell. For example :- Excel help is a best website and if you want to replace best with great you will use substitute function in excel. Example given below in image. IMPLEMENT : SUBSTITUTE Function is used when you want to replace any word in an existing sentence or words. First select the cell of existing text then enter the old word that need to change, then enter new word that need to replace and last (instance_num) is optional. Hit enter and its done.