Assignment 4

 IF FUNCTION👇👇

 The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect.

So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.

1. Insert an IF function

You can open a new Excel spreadsheet, decide where you want to see the result and click on that cell. Next, click the 'fx' button to bring up the function wizard and select the IF function. You can click the ‘OK' button.


2. Create a logical test

The next step is to decide on the condition you want to evaluate in Excel and enter it in the 'logical_test' field. 

3. Customise 'value_if_true'

The next field is 'value_if_true' and it is optional. You can leave it blank by writing "" into the field space. If you leave it blank and the condition is true, Excel generates a blank result. 

4. Customise 'value_if_false'

In Excel, the 'value_if_false' field designates a value if the condition is false. Otherwise, it is the same as the 'value_if_true' field.

5. Click ‘OK'

After entering data into the fields of 'logical_test,' 'value_if_true' and 'value_if_false,' click the 'OK' button. Check if the function has produced an accurate result. 

RESULT :

Comments

Post a Comment

Popular posts from this blog

Assignment 9

Image
  input variables and see the results. 4.  Create the Data Table For a One-Variable Table : Select the range of cells, including the sales, product and the cell with the formula. Go to the  Data  tab. Under the  What-If Analysis  group, click on  Data Table . In the  Data Table  dialog box: For  Row Input Cell , leave it blank (since we are changing the values in the column). For  Column Input Cell , select the cell that contains the sales. 5.  View Results After you click  OK , Excel will calculate the results and fill in the data table. You can now see how the 3 month sales change for each combination of  product and cost.
Read more

Assignment 7

Image
Assignment 7 USE OF HLOOKUP IN EXCEL In Excel to find and extract data from a table. By the end of these steps, you’ll be able to look up values horizontally across rows with confidence. Step 1: Open Your Excel Spreadsheet First, open your Excel spreadsheet where your data is stored. Make sure your table is well-organized with the necessary data laid out in rows. This organization is crucial for the HLOOKUP function to work correctly. Step 2: Select the Cell for the HLOOKUP Formula Choose the cell where you want the result of the HLOOKUP to appear. Click on an empty cell, which will be the destination for your lookup result. This will help you keep your data organized. Step 3: Enter the Hlookup  Formula In the selected cell, type . =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) Step 4: Press Enter After entering the formula, press Enter to execute it.   OUTPUT:
Read more

Assignment 3

  Pivot table Assignment no:3 Remove duplicate data January 31, 2025   Removing duplicate data is an essential step in data cleaning and preprocessing. Here are some methods to remove duplicate data: # Using Excel 1. *Select the data range*: Choose the cells that contain the data you want to remove duplicates from. 2. *Go to the "Data" tab*: Click on the "Data" tab in the ribbon. 3. *Click on "Remove Duplicates"*: Click on the "Remove Duplicates" button in the "Data Tools" group. 4. *Select the columns to check for duplicates*: Choose the columns you want to check for duplicates. 5. *Click "OK"*: Click "OK" to remove the duplicates. # Using Google Sheets 2. *Go to the "Data" menu*: Click on the "Data" menu. 3. *Select "Remove duplicates"*: Choose "Remove duplicates" from the drop-down menu. 4. *Select the columns to check for duplicates*: Choose the columns you want to check fo...
Read more