Excel Help
Sep 9, 2009 | 02:45 PM
Thread Starter
Joined: Oct 2005
Posts: 11,230
Likes: 0
From: South Bend/Walkerton, Ind
Excel Help
I need help completing this function with this criteria..I have the IF function set up, just don't know how to do the ranges...
ROI Category >=90% A >=80% and < 90% B >=70% and <80% C >=60% and <70% D
<60% F
Sep 9, 2009 | 02:58 PM
Joined: May 2002
Posts: 49,696
Likes: 1
From: Portland, OR
=IF(A1>=0.9,"A",IF(A1>=0.8,"B", IF(A1>=0.7,"C",IF(A1>=0.6,"D","F"))))
Sep 9, 2009 | 03:22 PM
Thread Starter
Joined: Oct 2005
Posts: 11,230
Likes: 0
From: South Bend/Walkerton, Ind
I'm using Return On Investment for 50 companies...I have a range of 50 random numbers and I need to distinguish them all from A-F
Sep 9, 2009 | 03:23 PM
Thread Starter
Joined: Oct 2005
Posts: 11,230
Likes: 0
From: South Bend/Walkerton, Ind
Sep 9, 2009 | 03:31 PM
Joined: May 2002
Posts: 49,696
Likes: 1
From: Portland, OR
I pretty much did it for you, you just have to plug that equation in for each company and change the reference cell in each one to match. You should be able to figure out the rest.
Sep 9, 2009 | 03:40 PM
Thread Starter
Joined: Oct 2005
Posts: 11,230
Likes: 0
From: South Bend/Walkerton, Ind
Sep 9, 2009 | 04:05 PM
Joined: Jun 2002
Posts: 42,568
Likes: 4
From: Buffalo, NY
you only seem to come around for homework help
Sep 9, 2009 | 04:13 PM
Thread Starter
Joined: Oct 2005
Posts: 11,230
Likes: 0
From: South Bend/Walkerton, Ind
Quote:
Originally Posted by
k3ifers
you only seem to come around for homework help
Coming down to the wire man..work + school is taking up all of my time..I still lurk around
Sep 9, 2009 | 04:15 PM
Joined: Jun 2002
Posts: 42,568
Likes: 4
From: Buffalo, NY
coming down to the wire? didn't you say you have three semesters left?
Sep 9, 2009 | 04:29 PM
Thread Starter
Joined: Oct 2005
Posts: 11,230
Likes: 0
From: South Bend/Walkerton, Ind
Quote:
Originally Posted by
k3ifers
coming down to the wire? didn't you say you have three semesters left?
78/ch...I need 123
After this semester I'll be 74% done.
Excel Help
