abqhusker

Posts: n/a

mmoran wrote:
I am a teacher and am working on excel for my grades. I am tyring to write a
formula that has an output of a letter grade. For example =if(AND (AQ3<100,
AQ390), "A" but then I want the condition of =if (AND(AQ3<89, AQ380),
"B" and so on.

How do I write this formula?

Megan

This is how I do it for my gradebook, just change the numbers and cell
references:

=IF(E4=0.91,"A",IF(E4=0.81,"B",
IF(E4=0.71,"C",IF(E4=0.61,"D","F"))))

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	1	June 6th 05 06:37 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Formula with multiple IF'S	Kim46770	Excel Discussion (Misc queries)	2	May 17th 05 10:31 PM
Multiple Condition Sumif Formula	momtoaj	Excel Worksheet Functions	3	April 6th 05 04:06 PM
Sum(if ... multiple conditions ... Interpretation?	Ken	Excel Discussion (Misc queries)	6	December 16th 04 10:23 PM

All times are GMT +1. The time now is 07:44 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us