multiple if condition

[esatkurtul]

hi everybody;

how can i do this if condition in app?

1<= [value] <=5            product will be 14

5< [value] < 15                      product will be 20

15<= [value] < infinity            product will be 26

[Derick_Paula]

use IFS()

[Derick_Paula]

for example:

ifs(and(1<= [value], [value] <=5),14,(and(5< [value] ,[value] < 15 ),20,(and(15<= [value],[value] < infinity ),26)

[esatkurtul]

it does not work 

[Steve · Accepted solution]

IFS(
  AND((1 <= [value]), ([value] <= 5)), 14,
  ([value] < 15), 20,
  TRUE, 26
)

[esatkurtul]

thank you 🙂

[douglasbeteta]

EN TODO HASTA A MI ME AYUDO GRACIAS