IF (formula Zoho Analytics)

Is there any way to create an "IF" condition that can search between two values, for example: >30 but <40, or something that can say "between these two numbers" to condition a field? In Excel, it exists, but in Zoho, the logic doesn't work the same way.

I have a column with margin, so I would like to create a formula that can express:

if M<$10, "bronze",

if M>=$10,M<$20,"silver",

if M >=$20,M<$30,"gold"

Is there any way to create this if in Zoho ?

Thank you in advance!