True/false formula on access

benj -
atimor - 19 Sep 2010 at 11:41

Hello,
I wrote this formula in Access: =IIf(([Note]<=20),[E],IIf(([Note]<=41),[D],IIf(([Note]<=61),[C],IIf(([Note]<=81),[B],IIf(([Note]<=100),[A]))))), but it doesn’t work, instead I see the message #Name?.
Does anyone know what the problem is in this formula?
It is used to score suppliers, I want to assign them a grade based on the points accumulated.
Thanks in advance

Configuration: Windows XP Internet Explorer 6.0

3 answers

Answer 1 / 3

benj

Got it! It was partly the " and also a matter of parentheses. The formula gives this: =IF([Totals]<=20,"E",IF([Totals]<=40,"D",IF([Totals]<=60,"C",IF([Totals]<=80,"B",IF([Totals]<=100,"A"))))).
Thank you for the help.

Answer 2 / 3

blux Posted messages 19185 Registration date Status Moderator Last intervention 3 452

Hello,

I don't know where this formula is typed, but do you want to try replacing vraifaux with iif, and maybe replacing the ; with , just in case?

--

A+ Blux

 "Les cons, ça ose tout. C'est même à ça qu'on les reconnaît"

benj

This formula is placed in a subform in a field called Note. I tried replacing the ; with , but it didn’t work.

blux Posted messages 19185 Registration date Status Moderator Last intervention 3 452 > benj

if your field is called 'note' and you put a formula that takes into account the value of 'note' to set the source of the field 'note', then you're chasing your tail... (in Excel, we would call that a circular reference)...

--

A+ Blux

 "The idiots, they dare everything. That's how we recognize them"

benj > blux Posted messages 19185 Registration date Status Moderator Last intervention

I noticed it but afterwards! I tried to change it again, there are no more errors in the formula but when the total increases, the number does not change accordingly, is it a problem with the comma or the quotes?
The formula gives this: =IF([Totals]<=20,1,IF([Totals]<=41,2,IF([Totals]<=61,3,IF([Totals]<=81,4,IF([Totals]<=100,5)))))

blux Posted messages 19185 Registration date Status Moderator Last intervention 3 452 > benj

me, I would put equal signs in front of the true-false...

--

A+ Blux

 "Fools will dare anything. It's even how we recognize them”

Answer 3 / 3

LatelyGeek Posted messages 1774 Registration date Status Member Last intervention 550

I don't understand why there are quotes around "[Totals]<=41"?????
--
Why make life complicated by doing simple things when it's so simple to make things complicated?

blux Posted messages 19185 Registration date Status Moderator Last intervention 3 452

Yeah, you’re right, I’m afraid it’s still 'true' since it’s a string, so without testing...

--

A+ Blux

 "Fools dare everything. That's even how we recognize them"

atimor

Hello everyone,
I am trying to do some calculations in my leave request, but I noticed that empty fields are not included in the calculations. For example: expr1=30, expr2: empty, expr3: which should be 30-0= 30. My request displays an empty field.
Please provide me with a solution.

True/false formula on access

3 answers

Iptv iron pro cut off

Fraudsters are now using your real iban in their phishing emails to rob you.

List numbering style

Pdf file

Set up a network

Unable to add an email account in outlook.

Sony wh-1000xm5 not turning on after getting wet

Google earth pro route not working at all

Texture issues in enshrouded

Usb port → usb serial