I didn't mean to infer you were a cheater. You said that. I did refer you to
the help index for IF because it is much more meaningful, as Gord said, that
you learn how to fish instead of being tossed fish. It does give a good
example of a nested if.

Formula Description (Result)
=IF(A289,"A",IF(A279,"B", IF(A269,"C",IF(A259,"D","F")))) Assigns
a letter grade to the first score (F)
=IF(A389,"A",IF(A379,"B", IF(A369,"C",IF(A359,"D","F")))) Assigns
a letter grade to the second score (A)
=IF(A489,"A",IF(A479,"B", IF(A469,"C",IF(A459,"D","F")))) Assigns
a letter grade to the third score (C)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
On Jul 19, 4:40 pm, Gord Dibben <gorddibbATshawDOTca wrote:
I am positive that would happen Don<g

Apologies for posting over your reply..........didn't see before replying.

Sometimes I take it too easy on the ones with class assignments.

Teach a man to fish might be a better solution as you point out.

Gord

On Sat, 19 Jul 2008 18:24:28 -0500, "Don Guillett"

wrote:



And be very sure to tell em that Gord gave it to you.- Hide quoted text -

- Show quoted text -

I'm not looking to get an "A". I was just looking for some help on
learning how to figure it out and I did email the teacher and let him
know I was looking for help on the internet. But I did finally figure
out an IF statement on my own. Gord, thanks for trying to help. Don,
I'm not a cheater, I was just stuck and looking for help. And yes I
did look on the insert function for help but I was still confused.
After emailing the teacher twice without a reply I went to the
internet for help, and your comments are making wish I hadn't.