OR Function
EXCEL OR FUNCTION Excel OR Function Introduction If all of its inputs are false, the OR function returns FALSE, and if one or more of them are true, it returns TRUE. As an example, if a salesperson exceeds the dollar sales budget or the unit sales budget, you may wish to reward her with a […]
DATE Function
EXCEL DATE FUNCTION Excel DATE Function Introduction This function will create a valid date from the values you supply as Year, Month and Day. Return value will be serial number represents a particular date in Excel (if you change the date format to general you can see the serial number). Description of Excel DATE Function […]
MATCH Function
EXCEL MATCH FUNCTION Excel MATCH Function Introduction This function looks for a given product in a range of cells and returns the relative location of that item in the range. For example, if the range A1:A3 contains the numbers 8, 39, and 54, then the formula =MATCH(39,A1:A3,0) yields the number 2, as 39 is the […]
INDEX Function
EXCEL INDEX FUNCTION Excel INDEX Function Introduction This function selects a value from a list or table by searching down the provided rows and across the specified columns. Description of INDEX Function Syntax: =INDEX (array, row_num, [col_num], [area_num]) Parameter list: array – a collection of cells, also known as an array constant. row number – […]
Indicators & Oscillators with their types
Indicators & Oscillators with their types Indicators & Oscillators with their types Table of Contents Indicators & Oscillators Indicators and oscillators are very helpful in technical analysis. By analyzing previous data, technical analysts use indicators and oscillators to estimate future price movements. Following are some of the popular indicators and oscillators. Price Indicators & Oscillators […]
IF Function
EXCEL IF FUNCTION Excel IF Function Introduction This function checks for a condition and returns the value you give if the condition is true, and a different value if the condition is false. Description of Excel IF Function Syntax: =IF (logical_test, [value_if_true], [value_if_false]) Parameter list: logical test – a value or logical expression that can […]
SUMIF Function
EXCEL SUMIF FUNCTION Excel SUMIF Function Introduction The SUMIF function belongs to the Math and Trigonometry category. It will total the cells that satisfy the specified conditions. Dates, numbers, and text are used as criterion. It accepts logical operators (>, >, =) as well as wildcards (*,?). This SumIf Excel function tutorial will show you […]
Four-wheeler Insurance : A Quick Guide
Four-wheeler Insurance : A Quick Guide Four-wheeler Insurance : A Quick Guide Table of Contents Introduction to Four-wheeler Insurance : A Quick Guide Car insurance protects you from financial loss if your vehicle is destroyed or stolen. Car insurance (often referred to as auto or motor insurance) is purchased to safeguard your car against unexpected […]
VLOOKUP Function
EXCEL VLOOKUP FUNCTION Excel VLOOKUP Function Introduction Vlookup is a versatile and strong technique in Excel that is often used for comparing excel sheets, extract.This function searches a table or cell ranges for the value you supply (searches in the table’s first column Description of Excel VLOOKUP Function Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Parameter list: […]
ERFC.PRECISE Function
EXCEL ERFC.PRECISE FUNCTION Excel ERFC.PRECISE Function Introduction The Excel Erfc.Precise function computes the Complementary Error Function, which is integrated between a lower limit specified and infinity. Description of Excel ERFC.PRECISE Function Syntax : =ERFC.PRECISE(x) Parameters : The lower limit of the complementary error function integral is denoted by x. Step By Step Guide of F.DIST […]