IIf statement to show A, B, C

  • Thread starter Thread starter Jill
  • Start date Start date
J

Jill

I have points calculated ... if they total 100 - then I want the field to say
A ... if the points are between 88 - 99 - then I want the field to say B ...
if the points are between 70 - 87 - then I want the field to say C.

I am not good with IIF statements - can anyone help?
 
IIF([Points] = 100, "A", IIF([Points] Between 88 AND 99, "B",
IIF([Points] Between 70 AND 87, "C", "F")))
 
Karl - thank you so very much for your help. I truly appreciate it ... it
worked great!!!

KARL DEWEY said:
IIF([Points] = 100, "A", IIF([Points] Between 88 AND 99, "B",
IIF([Points] Between 70 AND 87, "C", "F")))

--
Build a little, test a little.


Jill said:
I have points calculated ... if they total 100 - then I want the field to say
A ... if the points are between 88 - 99 - then I want the field to say B ...
if the points are between 70 - 87 - then I want the field to say C.

I am not good with IIF statements - can anyone help?
Click to expand...
Click to expand...
 
Back
Top