Question on Excel...if and functions

[ku jhawx]

I need some quick help on this Excel assignment...

I have to use an "ifand" function to fill in this table...

Here is the criteria...

A student is a Category 1 if they have a GPA >=3.8 AND a GMAT >=700
A student is a Category 2 if they have a GPA >=3.5 AND a GMAT >=700
A student is a Category 3 if they have a GPA >=3.0 AND a GMAT >=600
A student is a Category 4 if they have any other combo.


I'd really appreciate it guys! Thank you

 

[imreallydirknowitzki]

Mary Jackson is doing work.

 

[wr]

You should look up some time value of money and excel math tutorials. Seems like this is what you get paid for and peeps may be reluctant in helping you.

 

[omgitswes]

=IF(AND(A1>=3.8,B1>=700),"Category 1",IF(AND(A1>=3.5,B1>=700),"Category 2",IF(AND(A1>=3,B1>=600),"Category 3","Category 4")))


You'll need to change the variables to match your spreadsheet though, but that should work

 

[ku jhawx]

^^^^

Thank you sir. Savin me from getting an F on this assignment.

 

[omgitswes]

Ahhh man, I was thinking it was for your job rather than an assignment.
For future reference most formulas in Excel tell you what you need to put and where you need to put it.

 

[ku jhawx]

Yeah I had the right idea, just didn't have it EXACTLY right. Thanks though I appreciate it