Excel lesser than equal to not working

[sneha1889]

Hi guys i have an excel function lesser than equal to and it doesn't work right in some places. This is my formula.

IF(AND(C33>=A113;C33<=A117;C35>=A113;C35<=A117); ((MAIN!C15*8) +8+5)*10;"NO AREA MATCH")

In some cells it works and gives me the right value but in others the part in italics does not work.

For eg: if C33= 240 ; C35 = 300; A113=10; A117=50

The formula still gives me true thought he answer is No area match. Can you guys tell me why? I tries running "evalute formula and the part C33<=A117 is True when it is actually false. Can you tell me why this is happening and how I can correct it

Regards
Sneha

[Tony Valko]

You might have TEXT numbers in the cells even though they look like numeric numbers.

In Excel any text value is greater than any number. To test it try this formula:

="x">1000

On a cell where it doesn't work try testing that the cells are really numeric numbers:

=ISNUMBER(A117)

[FDibbins]

By using AND, you are saying that all tests must be true, not just some of them. If even 1 is not met, the whole AND part is false - you have TRUE/False/TRUE/FALSE

[sneha1889]

Hey Tony thank you. it worked. You were right

[Tony Valko]

Good deal. Thanks for the feedback!

[sneha1889]

my pleasure

[FDibbins]

Thanks for the feedback