software

I would like to use the IF function to return a grade value for a score. Ex:

If gradegt;70, then C
IFgradegt;80, then B, and so on.

I believe I need to imbed this function but don't know how. Please advise?

Thanks in advance.

One way:
You'll need to adjust the number grades as appropriate, but this should
help.

=IF(AND(A1gt;70,A1lt;81),quot;Cquot;,IF(AND(A1gt;80,A1lt;95),quot;Bquot;,I F(A1gt;94,quot;Aquot;)))

Regards,
Paul

quot;Redheadquot; gt; wrote in message
...
gt;I would like to use the IF function to return a grade value for a score.
gt;Ex:
gt;
gt; If gradegt;70, then C
gt; IFgradegt;80, then B, and so on.
gt;
gt; I believe I need to imbed this function but don't know how. Please
gt; advise?
gt;
gt; Thanks in advance.
Thanks. I tried it exactly as entered, and I still get an quot;invalidquot; error.

quot;PCLIVEquot; wrote:

gt; One way:
gt; You'll need to adjust the number grades as appropriate, but this should
gt; help.
gt;
gt; =IF(AND(A1gt;70,A1lt;81),quot;Cquot;,IF(AND(A1gt;80,A1lt;95),quot;Bquot;,I F(A1gt;94,quot;Aquot;)))
gt;
gt; Regards,
gt; Paul
gt;
gt; quot;Redheadquot; gt; wrote in message
gt; ...
gt; gt;I would like to use the IF function to return a grade value for a score.
gt; gt;Ex:
gt; gt;
gt; gt; If gradegt;70, then C
gt; gt; IFgradegt;80, then B, and so on.
gt; gt;
gt; gt; I believe I need to imbed this function but don't know how. Please
gt; gt; advise?
gt; gt;
gt; gt; Thanks in advance.
gt;
gt;
gt;

Not sure why you would get quot;invalidquot;. It seems to work on my side. If
there is more information that may be relevant, please post. Where does it
state quot;invalidquot;?

Regards,
Paul

quot;Redheadquot; gt; wrote in message
...
gt; Thanks. I tried it exactly as entered, and I still get an quot;invalidquot;
gt; error.
gt;
gt; quot;PCLIVEquot; wrote:
gt;
gt;gt; One way:
gt;gt; You'll need to adjust the number grades as appropriate, but this should
gt;gt; help.
gt;gt;
gt;gt; =IF(AND(A1gt;70,A1lt;81),quot;Cquot;,IF(AND(A1gt;80,A1lt;95),quot;Bquot;,I F(A1gt;94,quot;Aquot;)))
gt;gt;
gt;gt; Regards,
gt;gt; Paul
gt;gt;
gt;gt; quot;Redheadquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I would like to use the IF function to return a grade value for a score.
gt;gt; gt;Ex:
gt;gt; gt;
gt;gt; gt; If gradegt;70, then C
gt;gt; gt; IFgradegt;80, then B, and so on.
gt;gt; gt;
gt;gt; gt; I believe I need to imbed this function but don't know how. Please
gt;gt; gt; advise?
gt;gt; gt;
gt;gt; gt; Thanks in advance.
gt;gt;
gt;gt;
gt;gt;

here is another way that might work for you.

=IF(A1lt;60,quot;Fquot;,IF(AND(A1gt;=60,A1lt;70),quot;Dquot;,IF(AND(A1gt;= 70,A1lt;80),quot;Cquot;,IF(AND(A1gt;=80,A1lt;90),quot;Bquot;,IF(A1gt;=90,quot; Aquot;)))))--
goober
------------------------------------------------------------------------
goober's Profile: www.excelforum.com/member.php...oamp;userid=19838
View this thread: www.excelforum.com/showthread...hreadid=507785