AnsweredAssumed Answered

Required "Values between" Formula Calculation

Question asked by Suresh on Aug 19, 2016
Latest reply on Aug 19, 2016 by Suresh

Hi everyone,

 

Good day all!

 

I required a small clarification. Have some values & need to apply a concept.

 

If my Value(Score) <= 85 means set Field1's input as 1

85 < Value > 95 means 2

95 < Value > 100 means 3

100 < Value > 110 means 4

110 < means 5

 

So I use case function,

Here my calculation.

Case ( Score ≤ 85; 1; 85 ≤ Score ≥ 95; 2; 95 ≤ Score ≥ 100; 3; 100 ≤ Score ≥ 110; 4; Score ≥ 110; 5)

 

But I feel Result is coming wrongly, somewhere i did mistake!

 

Please suggest me where i did mistake!!

 

Suggestions & Solutions much appreciated!

 

- Suresh

Outcomes