Replace decimal with value if it meets criteria.

[prose3]

Hi all,

I have a dataset that, if the number is between 0.995 and 1, we want to keep the value at .99 so it does not round to 1 when pasted into an excel template.

On a very basic level my output looks like this:

Director	Category	Score 1	Score 2
Director 1	Cat 1	0.80	0.992
Director 2	Cat 1	N/A	0.9959
Director 3	Cat 1	0.997	1

I want the '0.997' and the '0.9959' replaced with '0.990' so it does not round to 1 in excel.

I've tried a formula tool with the output column Score 1 and the formula: "if 0.995 <= [Score 1] < 1 then 0.990 else [Score 1] endif". Can't get it to work. Data type is double.

I've also attached a more thorough sample doc (the Score columns are what should change).

Any help would be appreciated.

[JosephSerpis · Accepted solution]

Hi @prose3 you need the following syntax in your formula tool to work.

if 0.995 <= [Score 1] and [Score 1] < 1 then 0.990 else [Score 1] endif

[prose3]

@JosephSerpis thanks so much!