Struggling with IF THEN

Question

I'm struggling with an IF THEN and hoping you all might be able to help.  I have an output that will produce a number between 0 and 500.  The overall goal is to have the statement produce an output that calculates a relative risk level based on the output.  For example, if you received a score of 25 out of 500 (0 to 100 being 'Low Risk'), an additional column would be created showing 'Low Risk'.

I know this should be an easy solution but I've just been banging my head against the wall.

alexnajm · Accepted Answer

I would remove the string quotes from 100! As long as [Avg Deaths per 100,000] is stored numerically, this should work: IF [Avg Deaths per 100,000] > 100 THEN 'Low Risk' ELSE 'NA' ENDIF

alexnajm · Accepted Answer

Fantastic! Make sure to accept the solution(s) that helped so others can use these forums in the future as a reference 😊