Custom Column: New column to categorize value as one or another

[AW1976NOVA]

Hi,

In my master table (Claim Data Pull) there is a field named (Total Paid).  I would like to create a column in that table that specifies whether or not the Total Paid amount qualifies as a "High Cost Claim", a "Medium Cost Claim", or "Neither High or Medium Cost Claim".

1) A "High Cost Claim":  Greater than or equal to $50,000

2) A "Medium Cost Claim":  Is Greater Than or Equal to $25,000 and less than $50,000

I tried creating / using  a 'Conditional Column' but you can't specify inbetween ranges.

Please help.  Thank you.

[VasTg · Accepted solution]

@AW1976NOVA 

Add a custom column in query editor and paste this.

=if [Total Paid] >= "50000" then "High Cost Claim" else if [Total Paid] >= "25000" and [Total Paid] < "50000" then "Medium Cost Claim" else "Neither High or Medium Cost Claim"

If  this helps, mark it as a solution

Kudos are nice too