MS EXCEL FORMULAS
• =if(cell=””,””,ROW(1:1) →Auto serial no. fill
• =RANDBETWEEN(,) → Autofill random number {copy it and paste it then by paste special select values then ok}
• =count(range) → counts numeric cells only
• =counta(range) → counts all non-empty cells
• =countblank(range) → counts empty cells
• =countif(range,”criteria”) → counts cells that match a given condition
• =sum(range) → adds all numbers in the range
• =sumif(range, criteria, [sum_range]) → adds cells that meet one condition.
• =sumifs(sum_range, criteria_range1, criteria1, …) → adds cells that meet multiple conditions
• =subtotal(function_num, range) → returns subtotal like sum/average
• =IF(logical_test, value_if_true, [value_if_false]) → evaluates one condition and returns true/false values.
• =IF(condition1, value1, IF(condition2, value2, IF(condition3, value3, default))) → chains multiple conditions sequentially.
• =max(range) → finds the highest numeric value
• =min(range) → identifies the lowest numeric value
• =average(range) → calculates the arithmetic mean of numbers
• =ROMAN → For Roman numbers
• =POWER(cell unit, 2) → square
• =POWER(cell unit, 3) → cube
• =SQRT(square cell unit, 3) → Square Root
• =product(cell range) → Multiply
• =LOOKUP(lookup_vale,array)
• =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
• =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
