Greater Than Or Equal To (>=) not working?

Question

Greater Than Or Equal To (>=) not working?

Anonymous

I think there is an issue with my >= (greater than or equal to) function.

I have a formula to catch the L and W individuals, to only add them to the group (1) if they are at or above a 4.0 in the various levels.

Here's my monstrosity of a formula that's running in the "Grouping" column:

=IF(AND(OR(NOT([@NativeLanguage]="eng"),AND(NOT(ISBLANK([@HomeLanguage])),NOT([@HomeLanguage]="eng")),AND(NOT(ISBLANK([@OUTLANGUAGE])),NOT([@OUTLANGUAGE]="eng"))),OR([@[ELB]]="F",[@[ELB]]="4",[@[ELB]]="3",[@[ELB]]="2",[@[ELB]]="1",[@[ELB]]="n",AND(OR([@[ELB]]="L",[@[ELB]]="W"),[@[Composite Level]]>=4,[@[Literacy Level]]>=4,[@[Oral Level]]>=4,[@[Comprehension Level]]>=4))),1,0)

Here's a bit of the data set, too:

Grouping	NativeLanguage	HomeLanguage	ELB	Composite Level	Literacy Level	Oral Level	Comprehension Level
0	eng	ENG	E
1	ARA		F
1	ara		W	2.7	2.3	3.6	2.7
1	ara		N

1	ara			L	3.4	3.4	3.2	3.7
0	eng	ENG		E

1	SPA			L	4.2	4.3	4.1	3.8
1	spa	spa	spa	L	1.5	1.5	1.5

The bold portion of the formula is the part with the issue. I was troubleshooting it with F9, and it looks like ALL of the >= functions are returning true, even when the levels are below 4.0.

How do I fix this?

Thank you,

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Answer 1

Re: problem formula

A quick look:

your numbers are aligned to the left side of the cell.
Unless you did that intentionally they are being treated as text.
">=" doesn't usually work with text.

You can make sure the cell formatting is "General" and then

multiply your data by 1 (using paste special works).

'---

Nothing Left to Lose

Answer 2

Anonymous

They are formatted to numbers. I chose to have them go to that side

0 comments

Share via

Greater Than Or Equal To (>=) not working?

2 answers