How to calculate percentage in excel very easily
Calculating percentage of total in Excel
In fact, the above example is a particular case of calculating percentages of a total. Now, let's investigate a few more examples that will help you make quick work of calculating a percent of a total in Excel on different data sets.
Minimum Maximum Range calculation in excel
Excel MIN and MAX Functions
Find the lowest and highest values with the MIN and MAX functions.
To find the lowest value in a range of cells, use the MIN function. For example, this formula will find the lowest value in cells H2:H17
=MIN(H2:H17)
MAX Function
To find the highest value in a range of cells, use the MAX function. For example, this formula will find the highest value in cells H2:H17
=MAX(H2:H17)
To create a box-and-whisker plot, you start by ordering your data (putting the values in numerical order), if they aren't ordered already. Then you find the median of your data. The median divides the data into two halves. To divide the data into quarters, you then find the medians of these two
ABS function
This article describes the formula syntax and usage of the ABS function in Microsoft Excel.
Description
Returns the absolute value of a number. The absolute value of a number is the number without its sign.
Syntax
ABS(number)
The ABS function syntax has the following arguments:
Number Required. The real number of which you want the absolute value.
Example
Copy the table below, and paste into cell A1 in Excel. You may need to select any cells that contain formulas and press F2 and then Enter to make the formulas work. You may also want to make the columns wider to make your worksheet easier to read.
Data
-4
Formula
Description
Result
=ABS(2)
Absolute value of 2
2
=ABS(-2)
Absolute value of -2
2
=ABS(A2)
Absolute value of -4
4
Cell Counting Techniques
Category: Formulas | [Item URL]
Excel provides many ways to count cells in a range that meet various criteria:
The DCOUNT function. The data must be set up in a table, and a separate criterion range is required.
The COUNT function. Simply counts the number of cells in a range that contain a number.
The COUNTA function. Counts the number of non-empty cells in a range.
The COUNTBLANK function. Counts the number of empty cells in a range.
The COUNTIF function. Very flexible, but often not quite flexible enough.
An array formula. Useful when the other techniques won't work.
Formula Examples
Listed below are some formula examples that demonstrate various counting techniques. These formula all use a range named data.
To count the number of cells that contain a negative number:
=COUNTIF(data,"<0 10:="COUNTIF(data," 1="" a="" and="" any="" begins="" between="" case-sensitive="" case="" cells="" contain="" count="" data="" either="" letter="" no="" not="" number="" of="" or="" s="" sensitive="" text:="COUNTIF(data," text="" that="" the="" three-letter="" to="" value="" with="" word="" words:="COUNTIF(data," yes="">=1")-COUNTIF(data,">10")
To count the number of unique numeric values (ignores text entries):
=SUM(IF(FREQUENCY(data,data)>0,1,0))
To count the number of cells that contain an error value (this is an array formula, entered with Ctrl+Shift+Enter):
=SUM(IF(ISERR(data),1,0))
Using the formulas in VBA
You can also use these techniques in your VBA code. For example the VBA statement below calculates the number of three-letter words in a range named data, and assigns the value to the NumWords variable:
NumWords = Application.COUNTIF(Sheets("Sheet1").Range("data"), "???")
The other formula examples listed above can also be converted to VBA.
<0 10:="COUNTIF(data," 1="" a="" and="" any="" begins="" between="" case-sensitive="" case="" cells="" contain="" count="" data="" either="" letter="" no="" not="" number="" of="" or="" s="" sensitive="" text:="COUNTIF(data," text="" that="" the="" three-letter="" to="" value="" with="" word="" words:="COUNTIF(data," yes="">
<0 10:="COUNTIF(data," 1="" a="" and="" any="" begins="" between="" case-sensitive="" case="" cells="" contain="" count="" data="" either="" letter="" no="" not="" number="" of="" or="" s="" sensitive="" text:="COUNTIF(data," text="" that="" the="" three-letter="" to="" value="" with="" word="" words:="COUNTIF(data," yes="">
Ref: http://spreadsheetpage.com
