Mike Ferguson

Posts: n/a

I use a formula that does basically the same thing, converting point
totals into grades.
For example, if Column D contains total points (or percentages, as
shown below), I use this formula for Column E:

=IF(D190,"A",IF(D180,"B",IF(D170,"C",IF(D160," D","F"))))

I hope this helps.

-JMF

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
Pivot Table Zero Value	jcliquidtension	Excel Discussion (Misc queries)	12	January 13th 05 04:21 AM
Automatic return in an excel worksheet	Peggy	Excel Worksheet Functions	2	November 11th 04 01:52 AM
How to return min, mean, max using criteria?	stevenva	Excel Worksheet Functions	1	November 5th 04 01:34 AM
How to look up and return multiple values	Wendy	Excel Worksheet Functions	3	November 3rd 04 04:32 PM
VBA: Return Searched Value Inputed by End-User	Mcasteel	Excel Worksheet Functions	1	October 28th 04 03:09 PM

All times are GMT +1. The time now is 09:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us