How do I set the value between

[numfon_naka]

21.7 ± 0.15 (plus or minus)

I want it to be between 5.65 - 5.95. How should I set the formula?
Set the value between (not lower than) 21.55 (not higher than) 21.85

Sp1 is the specified value
NO.1 is the input value

[eyadiii]

Since [No.1] column is a number type, You can go to the column setting (the pencil button) and set the Minimum Value & Maximum Value.

[Aurelien]

Hi @numfon_naka 

Use a valid_if expression:

AND(
  [_THIS]>=21.55,
  [_THIS]<=21.85
)

 or

AND(
  [_THIS]>=(21.7-0.15),
  [_THIS]<=(21.7+0.15)
)

[numfon_naka]

SP is the value selected from the model
For example

1. If model A12 is selected, this value will be displayed (21.85 +- 0.15), which means the value must be between 21.7 and 22

2. If model A13 is selected, this value will be displayed (21.55 +- 0.15), which means the value must be between 21.4 and 21.7

It cannot be specified, or should we separate the columns or something?

[Aurelien]

Hi @numfon_naka 

---

@numfon_naka wrote:

SP is the value selected from the model

---

Hence my second suggestion 🙂

AND(
  [_THIS]>=(21.7-0.15),
  [_THIS]<=(21.7+0.15)
)

which will turn into:

AND(
  [_THIS]>=([SP_value]-0.15),
  [_THIS]<=([SP_value]+0.15)
)