Formula says Invalid type Operator

[roige_28]

I am new to creating workflows and I am getting an error when trying to change values in the same column. The result should be for amounts that are equal to or greater than 100 that the value should be 100 and if it is below 100 then it should be for the same amount. I tried this formula but keep on getting an error.

if [CLAIM_AMOUNT] >="120" then [CLAIM_AMOUNT] "120" else [CLAIM_AMOUNT] endif

[binuacs · Accepted solution]

@roige_28 

if [CLAIM_AMOUNT] >="120" then "120" else [CLAIM_AMOUNT] endif

[JosephSerpis · Accepted solution]

Hi @roige_28 if your column/field claim amount is a numeric data type then you don't need to put quotes around 120 and can delete claim amount for the then part argument of the If formula. You only need quotes for string arguements and not numeric.

if [CLAIM_AMOUNT] >=120 then 120 else [CLAIM_AMOUNT] endif

[flying008 · Accepted solution]

Hi, @roige_28 

FYI.

Min([CLAIM_AMOUNT], 120)

OR

IIF([CLAIM_AMOUNT]>= 120, 120, [CLAIM_AMOUNT])

[roige_28]

Thank you everyone for your help♥