Formulas

A collection of 22 posts

How To Use Not Equal To In Excel

In excel we are aware of operators like arithmetic and logical operators. Logical operators are mostly used in any organization to compare the two values either it is true or false. This logical
02 February 2020

How to Convert Measurements to Inches in Excel

Excel offers powerful conversion functionality to the user. You can apply simple equations across ranges of data to quickly produce new figures. Use this powerful feature to convert centimeters to inches in Excel.
02 February 2020

How To Use Calculate Percentage Discount In Excel

Excel provides you different ways to calculate percentages. For example, you can use Excel to calculate the percentage of correct answers on a test, discount prices using various percent assumptions, or percent change
02 February 2020

How to Subtract Cells in Excel

How to Subtract Cells in Microsoft Excel. Microsoft Excel tutorial on how to subtract using Microsoft excel. Check out the other microsoft excel videos and tutorials for more help in the “Microsoft
01 February 2020

How To Division Formula in Excel

Excel doesn’t have a divide function, so performing division in Excel requires you to create a formula. Let’s learn how to use formulas to divide numbers and calculate percentages
01 February 2020

How to use Square Root in Excel

A common engineering spreadsheet problem is solved by this quick tutorial on how to input square root. The tutorial shows how to do square root in Excel as well as how to calculate
01 February 2020

The various paste options in Excel

By default when you copy (or cut) and paste in Excel, everything in the source cell or range – data, formatting, formulas, validation, comments – is pasted to the destination cell(s). This
01 February 2020

9 helpful tips and formulas in EXCEL

Sum, Count, Average =SUM(A1:A10) Count =Count(A1:A10) Average =Average( Value1, Value2) If statements =IF(A1>A2, “GOOD”, “BAD”) Sumif, Countif, Averageif =SUM(A1:A15, “
12 January 2020