Hi,
I am trying to create a Crystal report on patients blood pressure readings and give them a score, example if BP is
under 140 the score is 0
if BP between 140 and 160 then the score is 1
if BP is over 160 the score is 2.
I would like it to look like this:

Patient BPSysgtolic#    Score
Joe X      134             0
Paul x     148             1
Jean x     169             2

If anyone have any suggestions I'll really appreciate any help
thank you

Hi Lockwelle,
it worked!!! thanks for your help.
I used the formula for other report like the example below and it worked just fine. Thanks again.

local numbervar phq9;

if {RPTOBS.obsvalue} < "15"
then phq9:= 0
else
if {RPTOBS.obsvalue} in "15 to 20"
then phq9:= 1 else
if {RPTOBS.obsvalue} > "20"
then phq9:= 2