Case Function Problem

[yakmada]

Case(number < "40000" ; "a" ; number >= "50000" ; "c" ; "b")

when i use the above formula, if the value in {number} is less than "100", the formula returns "c". likewise, if the value in {number} is greater than "99,999", the formula returns "a". other than that, it works just fine.

anybody know why this might be? ...how to get around it? ...the result is the same in v5.5 as it is in v7.0

thanks in advance.

.adam.

FileMaker Version: Dev 7

Platform: Mac OS X Panther

[MarkWilson]

Adam,

Remove the quotation marks from the numbers.

Case(number < 40000 ; "a" ; number >= 50000 ; "c" ; "b")

[yakmada]

thanks a lot! that did it.

.adam.

FileMaker Version: Dev 7

Platform: Mac OS X Panther