This is the opposite of IF AND. Unlike IF AND where the conditions have to be compulsorily met. IF OR only requires one condition to be met. Using the same example as in IF AND. You want a situation where goods that have their cost price higher than 3000 or their selling price higher than […]
IF AND statement is used to set two or more conditions in a table whereby those conditions must compulsorily be met before the values can be selected. This means that even if the first condition is met and the other one is not met that value cannot be selected. Take this for instance. You are […]
COUNTIF if used to count the numbers of cells that meet a given criteria within a specified range. The COUNTIF Formula will help you to Count all the cells containing a selected value or criteria. It counts all the cells that satisfy particular criteria. For example in a class of about 15 students you want […]
AVERAGEIF is used to find the average (arithmetic mean) of a given set of values of a given criteria within a specified range. It calculates the average of the cells that meet the given criteria. The first step is to type AVERAGEIF in a blank selected cell. The range is the array of values, […]
SUMIF is used to sum the set of values using a given criteria within a range of values. Let’s assume that there are students with the same score in a subjectand want to add their values altogether. . The SUMIF function allow excel to add only cells that meet criteria you choose. The first step is to […]
HOW TO USE “IF” FORMULA IN EXCEL? “If formula” in excel is used when a condition is set in a table. Sometimes a table may have many values and you want to select some set of values. For that to happen you make a condition so that the values that meet the condition can be […]
Data Table in Excel can be used to generate multiple result from your basic formular. This gives the opportunity to create multiple scenario from the two values (quantity and price). The example below will help you understand how to create data table in excel The initial data is formed by multiplying the quantity with price […]
Goal seek in Excel is a very good tool under “what if analysis” which are use to predict a desired output by changing the input that determines the output. Following the steps below will give you a better understanding how to use goal seek in excel. Step 1: Click on Data, followed by “What IF Analysis” […]
This will help you to update your worksheet columns especially when you need to insert a blank column between columns in excel What is Blank column in Excel? Blank column is an empty cells that is void of data i.e. cells with no data inputted. Inserting a blank column between columns in excel gives you […]
This will help you to update your worksheet rows especially when you need to insert a blank row between rows in excel What is Blank row in Excel? Blank row is an empty cells that is void of data i.e. cells with no data inputted. Inserting a blank row between rows in excel gives you […]
Solarex Information Technology World 2020 | All Rights Reserved.
