ASSIGNMENT GROUP BA213.docx

ASSIGNMENT GROUP BA213.docx - NESTED IF FUNCTION...

This preview shows page 1 - 5 out of 12 pages.

NESTED IF FUNCTION DOCUMENTATION Open new file in Microsoft Excel Insert data as shown below : Click cell E2 Insect function to find the Average Function: =AVERAGE(B2:D2) Then click Enter. The data will be shown as below : Then drag that until it shown the average in cell E8
Image of page 1

Subscribe to view the full document.

Next, click cell F2 Click insert IF function A dialog box like this will appear on your screen
Image of page 2
Insect theses data given below : Logical_test :E2>=16 Value_if_true: Excellent Value_if_false : click the if function in the name box When you click the IF function in the function arguments, the dialog box will appear again Then just continues insect the data given below Logical_test :E2>=14 Value_if_true: Very good Value_if_false : click the if function in the name box Logical_test :E2>=12 Value_if_true: Good Value_if_false : click the if function in the name box
Image of page 3

Subscribe to view the full document.

Logical_test :E2>=10 Value_if_true: Pass Value_if_false : Fail As shown in the figure below : Then click OK You will get result “Pass”
Image of page 4
Next, you just need to drag the cursor from cell F2:F8 You can now compare your answer with the results given below : Save the workbook
Image of page 5
You've reached the end of this preview.
  • Summer '17

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern