Newbies yakmada Posted April 4, 2004 Newbies Share Posted April 4, 2004 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 Link to comment Share on other sites More sharing options...
MarkWilson Posted April 4, 2004 Share Posted April 4, 2004 Adam, Remove the quotation marks from the numbers. Case(number < 40000 ; "a" ; number >= 50000 ; "c" ; "b") Link to comment Share on other sites More sharing options...
Newbies yakmada Posted April 4, 2004 Author Newbies Share Posted April 4, 2004 thanks a lot! that did it. .adam. FileMaker Version: Dev 7 Platform: Mac OS X Panther Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7326 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now