Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do I enter this function in excel to return the correct information? I have attached a picture of the excel spreadsheet that this task

How do I enter this function in excel to return the correct information? I have attached a picture of the excel spreadsheet that this task is referring to. I just can't figure out how to correctly enter this to get the requested information. My formula did not get the correct solution.

In the original Data worksheet, please do the following in a new column (and label it in Row 1; you can use any name): If someone has taken 12 or more INST HRS and RCR is N, then have the formula enter a star (*) in the cell in the new column; otherwise, have the formula leave it empty.

image text in transcribed
AutoSave O OFF A A B 6 - U 3 ModX assessment file v3 Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share Comment X A Conditional Formatting Format as Table Paste Font Alignment Number Cell Styles Cells Editing Ideas Sensitivity Create and Share Adobe PDF IF X V fx =IF(AND (D3>=12, 13="N")"* B C D G H K M N 0 P Q 12+/ No RCR ID DEGC CODE INST HRS TRANSFER HRS TERM HRS TOTAL HRS OVERALL GPA RCR TRUE MBA 11 3.93 N MPA 3.851 Y FALSE MPA 3.7 MBA 49 3.59 MBA 69 3.48 FALSE MPA 15 2.85 MPA 24 MBA 41 3.24 TRUE MPA 15 .56 11 MS 26 12 MS 13 MPA 14 MBA 1.25 TRUE 15 MS -2 2 -2 2 16 MBA .61 FALSE 17 MPA 12 18 MBA 19 MS TRUE 20 MBA 21 MBA 22 MPA FALSE 23 MPA 2 2 2 -2 24 MBA 25 MP ALSE 26 MPA MPA 28 MBA FALSE 29 MBA 2 2 30 MBA TRUE 31 MPA 32 MPA TRUE 33 MS 34 MBA .88 35 MBA 3.54 TRUE 36 MPA 3.75 37 MPA 1 85 TRUE 39 M TRUE MPA 3.82 MBA 3.88 2 2 2 2 2 -2 2 2- 43 MPA 1.07 MBA 21 3.33 Instructions Totals Sheet4 Data Results Courses Sheet5 DEGC Code + Edit 100%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information For Business Decisions

Authors: Loren A Nikolai, Billie Cunningham, John D Bazley

3rd Edition

1111066884, 9781111066888

More Books

Students also viewed these Accounting questions

Question

Do not pay him, wait until I come

Answered: 1 week ago

Question

Do not get married, wait until I come, etc.

Answered: 1 week ago

Question

Do not come to the conclusion too quickly

Answered: 1 week ago