Tom's Hardware > Forum > Applications > Other Software > QUESTION on EXCEL..
Ask the community Add a reply
Word :    Username :           
 
psowing200   09-27-2005 at 03:56:15 PM

frist hi to everyone..
actually my teacher asks me to do a project in excel..
but...i have a problem..when doing that..

"""Enter a formula in cell H3 to calculate and show the letter Grade for the first student. The criteria for the letter Grade assignment:
"A¡¨ >=85; "B" >=75; "C" >=60; "D" >=50; "F" <50
(Hint: using the function IF). Please try it out using Help menu if you don¡¦t understand the function IF.""

can anyone tell me how to do this?
i try it many times but still..fail

Add a reply
Sponsored Links
Register or log in to remove.
Riser   09-27-2005 at 04:46:35 PM
- 0 +

The IF function most likely won't cover the entire problem. You'll need create some form of a reference table.

=if(cell#>=85,refGradeACell,referenceanothercellformula)

So you'll want to create a reference somewhere stating what score determines what Grade.. and then you'll want to create formulas for A, B, C, D, F.. and each cell will reference the the table to determine what it is..

That would be a more efficient way.. you create the table and the formulas once.. then from there you have each cell reference the table..

The IF statement kind of works in there, but it's tedious.

What do you have so far?

Reply to Riser
fishmahn   10-03-2005 at 11:27:43 PM
- 0 +

You need to use a couple IF statements embedded inside the first IF statement to use it as the teacher suggests.

So I don't do your exercise for you, first make an IF statement that prints an A if the grade is >= 85, or a B otherwise.

When that works, then replace the B option with another IF statement to print B if grade is >= 75, otherwise a C. When that works, replace the C option with one to print C if grade is >= 60, otherwise a D. Do it one more time to replace the D option with one to print D if grade is >=50, otherwise F.

Riser's choice is better in terms of flexibility and using the power of Excel, but to show the power of the IF statement (and this early in the session), this is probably what the teacher had in mind.

Mike.

<font color=blue>Outside of a dog, a book is man's best friend. Inside the dog its too dark to read.
-- Groucho Marx</font color=blue>

Reply to fishmahn
Riser   10-04-2005 at 03:11:12 PM
- 0 +

That's why I hated taking these courses in College. They made you do it the hard way when I'm thinking "this way would be so much easier." I hated that.. But then again, I understand how it's trying to show the use of the IF statement.. but finding a better example is called for. This kind of teaching changes the way a student thinks on solving that kind of problem.

Reply to Riser
camieabz   10-04-2005 at 07:22:21 PM
- 0 +

Ahh. Nested IFs. Just so I could practice. Assuming that the score is in cell A1.

Formula in H3 would be:

IF(A1>=85,"A",IF(A1>=75,"B",IF(A1>=60,"C",IF(A1>=50,"D","E" ))))

Remember, you cannot have more than 7 nested IF statements in one formula.

<b><font color=blue>~ <A HREF="http://forums.btvillarin.com/index.php?act=ST&f=41&t=324&s=58e94ba84a16bedfebbf0f416d5bac48" target="_new">System Specs</A> ~<font color=blue></b> :wink:

Reply to camieabz
Riser   10-04-2005 at 07:59:53 PM
- 0 +

Of course! The dreaded "no more than 7 nested IFs.." Only if I had remembered that.. :)

Reply to Riser
Ask the community Add a reply
Tom's Hardware > Forum > Applications > Other Software > QUESTION on EXCEL..
Go to:

There are 1148 identified and unidentified users. To see the list of identified users, Click here.

Forum map
Bestofmedia Forum ©
2000-2009 Bestofmedia Group
Page generated in 0.440 seconds
Please mind

You are about to answer a thread that has been inactive for more than 6 months.
If you still wish to proceed, please ensure that your posting is original and does not duplicate or overlap any prior responses to this thread.

Add a reply Cancel
Sponsored links
  • Ask the community now
  • Publish
Ad
Related Topics
See all relatives topics
They won a badge
Join us in greeting them
How do I win badges?