About Us

Don Guillett

=.9

--
Don Guillett
SalesAid Software

"Zakhary" wrote in message
...
The only problem with this resolution is thaty it only will include
numbers
that are greater than .9, but not equal to. .9 need to be included
--
-Zakhary

"Don Guillett" wrote:

try this idea

IF(C7/C6.9,"A"),IF(C7/C6.8,"B"),ETC

--
Don Guillett
SalesAid Software

"Zakhary" wrote in message
...
Isn't there a "RANGE" formula that can be used complimentary with the
IF
formula?

I am grading some students' work and am looking to have a IF formula
that
divides the students' numeric points earned by the number of possible
points
and have the conditions be as follows:

RANGE GRADE
.9-1 A
.8-.89 B
.7-.79 C
.6-.69 D
0-.59 F

What I tried was this:
=IF(C7/C6=RANGE(.9,1),"A",IF(C7/C6=RANGE(.8,.89),"B",IF(C7/C6=RANGE(.7,.79),"C",IF(C7/C6=RANGE(.6,.69),"D","F"))))

However, this did not work because I am either using the RANGE formula
incorrectly or this formula doesn't even exist.

-Zakhary

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find value in array	Brook6	Excel Worksheet Functions	26	January 30th 07 09:40 PM
How do I enter formula that adds a range if less than a number or	Rose M	Excel Worksheet Functions	2	December 21st 05 08:30 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM
Formula for displaying the lowest number of a range?	coal_miner	Excel Worksheet Functions	1	April 25th 05 02:54 PM