IIf statement to show A, B, C

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?
 
K

KARL DEWEY

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

Jill

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIf statement sometimes works 3
IIF Statement Help 7
Access Building a IIF expression in Access 0
IIF Statement Too Complex. Need other solution. 5
Problem with IIf Statement 4
IIF Statement 2
Sum Iff Function 8
Printing iif results in a report 3

Top