Embedded Function for a range of answers

  • Thread starter Thread starter Boulder257
  • Start date Start date
B

Boulder257

I apologize because I know that someone has probably asked this before
but I have tried Ecel help and have searched the forum to no avail.

I want to create a formula that will give me a specific answer base
upon the results of a calculation in another cell. For instance, an
this isn't what I want to do, but it is the easiest way to explain it
Say that a cell would have a percentage in it, I want the formula fo
the next cell to result in a letter grade based upon the percentage i
the aformentioned cell. So, say there is an 89% in cell A1, A2 shoul
return a "B", but if there is a 79% in cell C1, then C2 should return
"C".

Any ideas
 
I apologize because I know that someone has probably asked this before,
but I have tried Ecel help and have searched the forum to no avail.

I want to create a formula that will give me a specific answer based
upon the results of a calculation in another cell. For instance, and
this isn't what I want to do, but it is the easiest way to explain it:
Say that a cell would have a percentage in it, I want the formula for
the next cell to result in a letter grade based upon the percentage in
the aformentioned cell. So, say there is an 89% in cell A1, A2 should
return a "B", but if there is a 79% in cell C1, then C2 should return a
"C".

Any ideas?
Click to expand...

Use VLOOKUP.

--ron
 
What you want to do is relatively easy to accomplish.

The actual approach to use is dependant on whether or not you have exact
criteria to match, or a range of criteria to produce a return.

10 = A
9 = B
8 = C

OR

10:8 = A
7:5 = B
4:2 = C

You can use either Lookup or Vlookup functions in conjunction with a
datalist to reference, or if the list is small enough, it can be hardcoded
right into the actual formula.

Lookup those functions in the Help files, and postback with questions.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------


in message
I apologize because I know that someone has probably asked this before,
but I have tried Ecel help and have searched the forum to no avail.

I want to create a formula that will give me a specific answer based
upon the results of a calculation in another cell. For instance, and
this isn't what I want to do, but it is the easiest way to explain it:
Say that a cell would have a percentage in it, I want the formula for
the next cell to result in a letter grade based upon the percentage in
the aformentioned cell. So, say there is an 89% in cell A1, A2 should
return a "B", but if there is a 79% in cell C1, then C2 should return a
"C".

Any ideas?
 
Boulder

Example only. Adapt for your scores and grades.

=LOOKUP(A1,{0,51,70,86},{"D","C","B","A"})

Note the curly braces internally.

Enter this formula in A2 and enter the score in A1.


Gord Dibben Excel MVP
 
Back
Top