Question

Provide an example of a logical excel function and describe a situation when we might use it in a spreadsheet.

How can we work with spreadsheets that contain large numbers of rows and columns and not lose our place or get lost in what we’re looking at. Your main post should be at least 250-300 words long.

-spreadsheet management.

Answer 1

Answer

We can get the desired outcome of results (Eg Sum, Median, either condition, both condition and if condition etc.) by using logical excel functions while doing calculations in excel spreadsheet.

There are many types of logical excel functions

1. IF Function

2. AND Function

3. OR Function

4. XOR Function

5. NOT Function

6. MAX, MIN Functions

7. SEARCH Function

8. LOOKUP Functions (Vertical and Horizontal)...etc

Example of logical excel function

Abhi scored in subject A 45 marks and in subject B 52 Marks

AND Function: Abhi will get pass when he score 50 above marks in both subjects. Then logical function can be used as under

NAME	SUBJECT"A"	SUBJECT "B"	LOGICAL FUNCTION
Abhi	45	52	=AND(B2>50,C2>50)

OR Function: Abhi will get pass when he score 50 above marks in either of the subjects. Then logical function can be used as under

NAME	SUBJECT"A"	SUBJECT "B"	LOGICAL FUNCTION
Abhi	45	52	=OR(B2>50,C2>50)

Situation when we use logical functions in excel spreadsheets.

Usually we use logical excel functions when we required to get results from a combination of data with the functions of addition, deletion, matching, comparision and looking up etc.. while doing work in large spreadsheet which contains large number of rows and columns it is difficult to get results for each and every data combination manually. Hence by using logical excel functions while doing work in such type of large spreadsheets we can reduce the time for work done and errors.

We can work with spreadsheets which contains large number of rows and columns by using the excel logical functions effectively and by searching the what we are looking at in the spreadsheet. We should work with particulat and specified data and apply the functions to all the rows and columns in the spread sheet. We should save the excel file after each task we did and should be verified whether the outcome results are correct or not. By using the search functions and filter functions we can work with some specified data even the spreadsheet contains large number of rows and columns. By using and implementing the above said functions we can work with spreadsheets which contain large number of rows and columns by not losing our place or get lost what we are looking at.