IFS Lógica Error

[Antonio_Aguilar]

I´m Working with this Formula:

IFS(
( [Monthly Rent] <= 100 ), 35,
( [Monthly Rent] > 100) and ([Monthly Rent] <= 300), 495,
( [Monthly Rent] > 300), 995,

TRUE, “Verify Rent Amount”
)

But the “and” is ignored by appsheet formula editor and doesn´t consider values >300.

Thanks for the comment…!!