Can anyone tell me why this does not work? I get very strange and unpredictable results.

Note: y_Cost is a field which holds the cost of an item. I'm trying to develop a mark-up price for that item:

CASE (

y_Cost < "5" ; y_Cost * "4" ;

y_Cost > "5.01" and y_Cost < "15" ; y_Cost * "3.5" ;

y_Cost > "14.99" and y_Cost < "25" ; y_Cost * "3" ;

y_Cost > "24.99" and y_Cost < "40" ; y_Cost * "2.75" ;

y_Cost > "39.99" and y_Cost < "60" ; y_Cost * "2.5" ;

y_Cost > "59.99" and y_Cost < "100" ; y_Cost * "2.25" ;

y_Cost > "99.99" and y_Cost < "200" ; y_Cost * "2" ;

y_Cost > "199" ; y_Cost * "1.6"

)

Hi,

I notice the quotation marks around the numbers. Is this a calculation field which is set to give a Number result ? or a text result?

(FM version and operating system is always good background info for folks who want to help)