Hi, I need help with finding a value from a long list.

I think I need PPressTalk to use a "case" statement or equivalent method to find the answer rather then creating so many conditions!

The value can be found by checking the "age" and "gender"
For example


if ( age = 50 ) and (gender = M )
benefit = $2500
if ( age = 51 ) and (gender = F )
benefit = $3500
....
....
if ( age = 85 ) and (gender = M )
benefit = $1500

Can you help please.

THANKS
_________________________
Peace