I have a field called "State Withholding Tax". In it I need it to look at "Gross_f" and if it is between 0 and 30, it will show 0.00. If it is between 30 and 85, it will show 1.00. If it is between 85 and 140, it will show 2.00. And finally if it is between 140 and 160, it will show 3.00. I tried this

Case ( 

Gross_F = 0 & < 30 ; 0.00

; Gross_F > 30 & < 85 ; 1.00 

; Gross_F > 85 & < 140 ; 2.00 )

But it doesn't work. Any advice.

Thanks

Case (

Gross_F >= 0 and Gross_F < 30 ; 0;

Gross_F > 30 and Gross_F < 85 ; 1;

Gross_F > 85 and Gross_F < 140; 2

)

or if you dont have any mumber lower than 0 then it can simply be:

Case (

Gross_F < 30 ; 0;

Gross_F < 85 ; 1;

Gross_F < 140; 2

)

Edited March 17, 200817 yr by Guest

Sorry, I have not replied in a while. Had pnemonia and out of service for quite some time. Close call I guess. I really appreciate your help, I will work on the formula and get back to ya. Thank you very much.