Assignment 9 Mathematics and Logical Function Count Related Function
Mathematics and LogicalCount Related Function
Function Use COUNTIF :- Countif function count the number of cell in a range, that meet a given criteria.COUNTA:- CountA function to count cell that contain numbers, text , logical value, error values and empty text (" ") it means space.COUNTIFS:- Countifs function is used for counting cell within a specific range that meet a certain criteria or condition. for example you can write a countifs formula to find out how many…
Assignment 22 Lookup Function related assignment Lookup detail by the course name
Assignment 22 Lookup Function related assignment
Lookup detail by the course name
Function used
IFERROR :- Iferror function manage error in formula and calculation. Ifarror check a formula and if it evaluates to an error, returns another values you specify. otherwise return the result of the formula.VLOOKUP :- This function use to when you need to find detail in a table or a range by row.LEFT :- Left function extract a given number of character from left side.RIGHT :- This fun…
Assignment 21 Lookup Function related assignment Sale Question
Assignment 21 Lookup Function related assignmentSale Question
Function Used
SUMIF :- this function return the addition number of cells that supplied criteria.VLOOKUP :- This function use to when you need to find detail in a table or a range by row.
Function Use in that cells
=SUMIF($E$4:$E$14,VLOOKUP($D$18,$B$3:$C$14,2,0),$F$4:$F$14)SUMIF:- if the condition is meet it will add the range.(2) :- Column index number.$F$4:$F$14 :- cell range with dollar in a main table (sale).$E$4:$…
Assignment 20 Lookup Function related assignment Lookup value Dashboard
Assignment 20 Lookup Function related assignmentLookup value Dashboard
Function Used
VLOOKUP :- The vlookup function is used fo, when you need to find thing in a table or a range by row.COLUMN :- The excel column function return the column number for a reference.
Function use in that=VLOOKUP(VLOOKUP($E$12,$G$4:$H$8,2,0),$B$4:$E$8,COLUMN(B4),0)VLOOKUP:- find things in a table or a range by row.Column :- this function return the column number.(2):- column index number.(B4) cell a…
Assignment 19 String Function Mid name and unique entries
Assignment 19 String FunctionMid name and unique entries
Function Used
MID :- This function gives number of character from the middle of text.SEARCH:- This function use to find specific text in a string and give the number of location in string.Index Function :- The Excel index function return the value at a given position in a range or array you can use index to retrieve individual values or entire rows and columns. Index is often used with the Match function, where Match loc…
Assignment 17 String Function Number of word and last word from a string
Assignment 17 String Function
Number of word and last word from a string
Function Used
LEN :- the LEN function return the length of a given text string as the number of characters. LEN will also count characters in numbers.TRIM :- trim function strips extra spaces from text, leaving only a single space between words and no space characters at the start or end of the text.SUBSTITUTE :- substitute function replace text in a given string by matching. Ex:- Substitue ("952-455-…
Assignment 16 Date Function Cyber Cafe
Assignment 16 Date FunctionCyber Cafe
Function Used
IF :- IF function can perform a logical test and return one value for a true result and another for a false result it use to manuplate return the value "TRUE" and "FALSE".NOW :- this function return the current date and time, updated continuously when a worksheet is change or opened.HOUR :- this function return the hour component of a number 0-23 for example with a time of 9:30 am hours will return 9.MINU…
.JPG)
Follow Us on